Overview
Brought to you by YData
Dataset statistics
| Number of variables | 49 |
|---|---|
| Number of observations | 203002 |
| Missing cells | 555 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 37.0 MiB |
| Average record size in memory | 191.2 B |
Variable types
| Numeric | 13 |
|---|---|
| DateTime | 5 |
| Categorical | 28 |
| Boolean | 3 |
id_empresa has constant value "1" | Constant |
nombre_empresa has constant value "Hotel 1" | Constant |
total_habitaciones_empresa has constant value "735" | Constant |
cupo_tipo_habitacion has constant value "2.0" | Constant |
id_moneda has constant value "1" | Constant |
id_agencia has a high cardinality: 120 distinct values | High cardinality |
nombre_agencia has a high cardinality: 112 distinct values | High cardinality |
ciudad_agencia has a high cardinality: 56 distinct values | High cardinality |
clave_estado has a high cardinality: 148 distinct values | High cardinality |
nombre_estado has a high cardinality: 144 distinct values | High cardinality |
ciudad_agencia is highly overall correlated with entidad_federativa_agencia and 3 other fields | High correlation |
clasificacion_tipo_habitacion is highly overall correlated with id_tipo_habitacion and 1 other fields | High correlation |
cliente_disp_anio_anterior is highly overall correlated with id_reservaciones and 12 other fields | High correlation |
entidad_federativa_agencia is highly overall correlated with ciudad_agencia and 1 other fields | High correlation |
id_canal is highly overall correlated with nombre_canal | High correlation |
id_cliente_disp is highly overall correlated with numero_adultos and 4 other fields | High correlation |
id_estatus_reservacion is highly overall correlated with nombre_estatus_reservacion | High correlation |
id_pais_origen is highly overall correlated with nombre_pais_origen | High correlation |
id_paquete is highly overall correlated with id_programa and 2 other fields | High correlation |
id_programa is highly overall correlated with id_paquete and 2 other fields | High correlation |
id_reservaciones is highly overall correlated with cliente_disp_anio_anterior and 12 other fields | High correlation |
id_segmento is highly overall correlated with ciudad_agencia and 2 other fields | High correlation |
id_tipo_habitacion is highly overall correlated with clasificacion_tipo_habitacion and 1 other fields | High correlation |
nombre_canal is highly overall correlated with id_canal | High correlation |
nombre_estatus_reservacion is highly overall correlated with id_estatus_reservacion | High correlation |
nombre_pais_origen is highly overall correlated with id_pais_origen | High correlation |
nombre_paquete is highly overall correlated with id_paquete and 2 other fields | High correlation |
nombre_programa is highly overall correlated with id_paquete and 2 other fields | High correlation |
nombre_segmento is highly overall correlated with ciudad_agencia and 2 other fields | High correlation |
nombre_tipo_habitacion is highly overall correlated with clasificacion_tipo_habitacion and 1 other fields | High correlation |
numero_adultos is highly overall correlated with cliente_disp_anio_anterior and 13 other fields | High correlation |
numero_adultos_anio_anterior is highly overall correlated with cliente_disp_anio_anterior and 12 other fields | High correlation |
numero_noches is highly overall correlated with cliente_disp_anio_anterior and 9 other fields | High correlation |
numero_noches_anio_anterior is highly overall correlated with cliente_disp_anio_anterior and 9 other fields | High correlation |
numero_personas is highly overall correlated with cliente_disp_anio_anterior and 10 other fields | High correlation |
numero_personas_anio_anterior is highly overall correlated with cliente_disp_anio_anterior and 9 other fields | High correlation |
pais_agencia is highly overall correlated with ciudad_agencia and 3 other fields | High correlation |
reservacion is highly overall correlated with cliente_disp_anio_anterior and 8 other fields | High correlation |
reservacion_anio_anterior is highly overall correlated with cliente_disp_anio_anterior and 8 other fields | High correlation |
reservacion_pendiente is highly overall correlated with cliente_disp_anio_anterior and 8 other fields | High correlation |
total_habitaciones is highly overall correlated with cliente_disp_anio_anterior and 12 other fields | High correlation |
total_habitaciones_anio_anterior is highly overall correlated with cliente_disp_anio_anterior and 12 other fields | High correlation |
total_tarifa is highly overall correlated with cliente_disp_anio_anterior and 9 other fields | High correlation |
id_programa is highly imbalanced (97.5%) | Imbalance |
nombre_programa is highly imbalanced (97.5%) | Imbalance |
id_paquete is highly imbalanced (60.9%) | Imbalance |
nombre_paquete is highly imbalanced (60.9%) | Imbalance |
pais_agencia is highly imbalanced (86.1%) | Imbalance |
id_pais_origen is highly imbalanced (96.3%) | Imbalance |
nombre_pais_origen is highly imbalanced (96.3%) | Imbalance |
clave_estado is highly imbalanced (55.8%) | Imbalance |
nombre_estado is highly imbalanced (55.5%) | Imbalance |
id_cliente_disp is highly imbalanced (60.9%) | Imbalance |
numero_noches is highly skewed (γ1 = 81.01891754) | Skewed |
numero_noches_anio_anterior is highly skewed (γ1 = 82.30675646) | Skewed |
total_tarifa is highly skewed (γ1 = 26.89402197) | Skewed |
id_reservaciones is uniformly distributed | Uniform |
id_reservaciones has unique values | Unique |
numero_personas has 100803 (49.7%) zeros | Zeros |
numero_personas_anio_anterior has 102199 (50.3%) zeros | Zeros |
numero_adultos has 100803 (49.7%) zeros | Zeros |
numero_adultos_anio_anterior has 102199 (50.3%) zeros | Zeros |
numero_menores has 198413 (97.7%) zeros | Zeros |
numero_menores_anio_anterior has 198466 (97.8%) zeros | Zeros |
numero_noches has 101006 (49.8%) zeros | Zeros |
numero_noches_anio_anterior has 102402 (50.4%) zeros | Zeros |
total_habitaciones has 101049 (49.8%) zeros | Zeros |
total_habitaciones_anio_anterior has 102445 (50.5%) zeros | Zeros |
total_tarifa has 106391 (52.4%) zeros | Zeros |
cliente_disp_anio_anterior has 102199 (50.3%) zeros | Zeros |
Reproduction
| Analysis started | 2025-05-11 19:29:04.390027 |
|---|---|
| Analysis finished | 2025-05-11 19:29:57.886285 |
| Duration | 53.5 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
id_reservaciones
Real number (ℝ)
High correlation  Uniform  Unique 
| Distinct | 203002 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 101500.5 |
| Minimum | 0 |
|---|---|
| Maximum | 203001 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 10150.05 |
| Q1 | 50750.25 |
| median | 101500.5 |
| Q3 | 152250.75 |
| 95-th percentile | 192850.95 |
| Maximum | 203001 |
| Range | 203001 |
| Interquartile range (IQR) | 101500.5 |
Descriptive statistics
| Standard deviation | 58601.774 |
|---|---|
| Coefficient of variation (CV) | 0.57735454 |
| Kurtosis | -1.2 |
| Mean | 101500.5 |
| Median Absolute Deviation (MAD) | 50750.5 |
| Skewness | -8.5222189 × 10-16 |
| Sum | 2.0604805 × 1010 |
| Variance | 3.4341679 × 109 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 203001 | 1 | < 0.1% |
| 0 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
| 2 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 7 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| Other values (202992) | 202992 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 203001 | 1 | |
| 203000 | 1 | |
| 202999 | 1 | |
| 202998 | 1 | |
| 202997 | 1 | |
| 202996 | 1 | |
| 202995 | 1 | |
| 202994 | 1 | |
| 202993 | 1 | |
| 202992 | 1 |
fecha_hoy
Date
| Distinct | 824 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
| Minimum | 2019-01-02 00:00:00 |
|---|---|
| Maximum | 2021-12-03 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
| Distinct | 482 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
| Minimum | 2019-01-02 00:00:00 |
|---|---|
| Maximum | 2020-12-04 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
fecha_llegada
Date
| Distinct | 713 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 1.5 MiB |
| Minimum | 2019-01-03 00:00:00 |
|---|---|
| Maximum | 2021-12-06 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
fecha_salida
Date
| Distinct | 722 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 34 |
| Missing (%) | < 0.1% |
| Memory size | 1.5 MiB |
| Minimum | 2019-01-03 00:00:00 |
|---|---|
| Maximum | 2021-12-06 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
numero_personas
Real number (ℝ)
High correlation  Zeros 
| Distinct | 22 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.1858652 |
| Minimum | 0 |
|---|---|
| Maximum | 32 |
| Zeros | 100803 |
| Zeros (%) | 49.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 32 |
| Range | 32 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.3696288 |
|---|---|
| Coefficient of variation (CV) | 1.1549616 |
| Kurtosis | 17.748518 |
| Mean | 1.1858652 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.7961185 |
| Sum | 240733 |
| Variance | 1.875883 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 100803 | |
| 2 | 71889 | |
| 3 | 15053 | 7.4% |
| 4 | 7789 | 3.8% |
| 1 | 4928 | 2.4% |
| 5 | 1280 | 0.6% |
| 6 | 785 | 0.4% |
| 8 | 228 | 0.1% |
| 7 | 96 | < 0.1% |
| 12 | 40 | < 0.1% |
| Other values (12) | 111 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 100803 | |
| 1 | 4928 | 2.4% |
| 2 | 71889 | |
| 3 | 15053 | 7.4% |
| 4 | 7789 | 3.8% |
| 5 | 1280 | 0.6% |
| 6 | 785 | 0.4% |
| 7 | 96 | < 0.1% |
| 8 | 228 | 0.1% |
| 9 | 17 | < 0.1% |
| Value | Count | Frequency (%) |
| 32 | 10 | < 0.1% |
| 20 | 2 | < 0.1% |
| 19 | 5 | < 0.1% |
| 18 | 6 | < 0.1% |
| 17 | 13 | < 0.1% |
| 16 | 8 | < 0.1% |
| 15 | 2 | < 0.1% |
| 14 | 6 | < 0.1% |
| 13 | 3 | < 0.1% |
| 12 | 40 |
numero_personas_anio_anterior
Real number (ℝ)
High correlation  Zeros 
| Distinct | 22 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.17055 |
| Minimum | 0 |
|---|---|
| Maximum | 32 |
| Zeros | 102199 |
| Zeros (%) | 50.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 32 |
| Range | 32 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.3680725 |
|---|---|
| Coefficient of variation (CV) | 1.1687433 |
| Kurtosis | 17.777041 |
| Mean | 1.17055 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.8060301 |
| Sum | 237624 |
| Variance | 1.8716224 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 102199 | |
| 2 | 70655 | |
| 3 | 14990 | 7.4% |
| 4 | 7732 | 3.8% |
| 1 | 4913 | 2.4% |
| 5 | 1276 | 0.6% |
| 6 | 779 | 0.4% |
| 8 | 215 | 0.1% |
| 7 | 96 | < 0.1% |
| 12 | 38 | < 0.1% |
| Other values (12) | 109 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 102199 | |
| 1 | 4913 | 2.4% |
| 2 | 70655 | |
| 3 | 14990 | 7.4% |
| 4 | 7732 | 3.8% |
| 5 | 1276 | 0.6% |
| 6 | 779 | 0.4% |
| 7 | 96 | < 0.1% |
| 8 | 215 | 0.1% |
| 9 | 17 | < 0.1% |
| Value | Count | Frequency (%) |
| 32 | 10 | < 0.1% |
| 20 | 2 | < 0.1% |
| 19 | 5 | < 0.1% |
| 18 | 6 | < 0.1% |
| 17 | 13 | < 0.1% |
| 16 | 8 | < 0.1% |
| 15 | 1 | < 0.1% |
| 14 | 6 | < 0.1% |
| 13 | 3 | < 0.1% |
| 12 | 38 |
numero_adultos
Real number (ℝ)
High correlation  Zeros 
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.0947084 |
| Minimum | 0 |
|---|---|
| Maximum | 15 |
| Zeros | 100803 |
| Zeros (%) | 49.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 15 |
| Range | 15 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.2070762 |
|---|---|
| Coefficient of variation (CV) | 1.1026463 |
| Kurtosis | 4.3490022 |
| Mean | 1.0947084 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.057326 |
| Sum | 222228 |
| Variance | 1.4570329 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 100803 | |
| 2 | 80295 | |
| 3 | 12016 | 5.9% |
| 1 | 5654 | 2.8% |
| 4 | 2962 | 1.5% |
| 5 | 536 | 0.3% |
| 6 | 427 | 0.2% |
| 8 | 156 | 0.1% |
| 7 | 43 | < 0.1% |
| 15 | 24 | < 0.1% |
| Other values (6) | 86 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 100803 | |
| 1 | 5654 | 2.8% |
| 2 | 80295 | |
| 3 | 12016 | 5.9% |
| 4 | 2962 | 1.5% |
| 5 | 536 | 0.3% |
| 6 | 427 | 0.2% |
| 7 | 43 | < 0.1% |
| 8 | 156 | 0.1% |
| 9 | 20 | < 0.1% |
| Value | Count | Frequency (%) |
| 15 | 24 | < 0.1% |
| 14 | 8 | < 0.1% |
| 13 | 4 | < 0.1% |
| 12 | 22 | < 0.1% |
| 11 | 9 | < 0.1% |
| 10 | 23 | < 0.1% |
| 9 | 20 | < 0.1% |
| 8 | 156 | 0.1% |
| 7 | 43 | < 0.1% |
| 6 | 427 |
numero_adultos_anio_anterior
Real number (ℝ)
High correlation  Zeros 
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.0796938 |
| Minimum | 0 |
|---|---|
| Maximum | 15 |
| Zeros | 102199 |
| Zeros (%) | 50.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 15 |
| Range | 15 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.2046937 |
|---|---|
| Coefficient of variation (CV) | 1.1157735 |
| Kurtosis | 4.2151962 |
| Mean | 1.0796938 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.0595136 |
| Sum | 219180 |
| Variance | 1.451287 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 102199 | |
| 2 | 79038 | |
| 3 | 11946 | 5.9% |
| 1 | 5638 | 2.8% |
| 4 | 2933 | 1.4% |
| 5 | 534 | 0.3% |
| 6 | 422 | 0.2% |
| 8 | 143 | 0.1% |
| 7 | 43 | < 0.1% |
| 10 | 23 | < 0.1% |
| Other values (6) | 83 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 102199 | |
| 1 | 5638 | 2.8% |
| 2 | 79038 | |
| 3 | 11946 | 5.9% |
| 4 | 2933 | 1.4% |
| 5 | 534 | 0.3% |
| 6 | 422 | 0.2% |
| 7 | 43 | < 0.1% |
| 8 | 143 | 0.1% |
| 9 | 19 | < 0.1% |
| Value | Count | Frequency (%) |
| 15 | 23 | < 0.1% |
| 14 | 8 | < 0.1% |
| 13 | 4 | < 0.1% |
| 12 | 20 | < 0.1% |
| 11 | 9 | < 0.1% |
| 10 | 23 | < 0.1% |
| 9 | 19 | < 0.1% |
| 8 | 143 | 0.1% |
| 7 | 43 | < 0.1% |
| 6 | 422 |
numero_menores
Real number (ℝ)
Zeros 
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.034108038 |
| Minimum | 0 |
|---|---|
| Maximum | 15 |
| Zeros | 198413 |
| Zeros (%) | 97.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 15 |
| Range | 15 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.26518667 |
|---|---|
| Coefficient of variation (CV) | 7.7749023 |
| Kurtosis | 582.05071 |
| Mean | 0.034108038 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 16.064875 |
| Sum | 6924 |
| Variance | 0.070323969 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 198413 | |
| 1 | 2730 | 1.3% |
| 2 | 1619 | 0.8% |
| 3 | 168 | 0.1% |
| 4 | 31 | < 0.1% |
| 5 | 17 | < 0.1% |
| 15 | 10 | < 0.1% |
| 7 | 7 | < 0.1% |
| 6 | 6 | < 0.1% |
| 8 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 198413 | |
| 1 | 2730 | 1.3% |
| 2 | 1619 | 0.8% |
| 3 | 168 | 0.1% |
| 4 | 31 | < 0.1% |
| 5 | 17 | < 0.1% |
| 6 | 6 | < 0.1% |
| 7 | 7 | < 0.1% |
| 8 | 1 | < 0.1% |
| 15 | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| 15 | 10 | < 0.1% |
| 8 | 1 | < 0.1% |
| 7 | 7 | < 0.1% |
| 6 | 6 | < 0.1% |
| 5 | 17 | < 0.1% |
| 4 | 31 | < 0.1% |
| 3 | 168 | 0.1% |
| 2 | 1619 | 0.8% |
| 1 | 2730 | 1.3% |
| 0 | 198413 |
numero_menores_anio_anterior
Real number (ℝ)
Zeros 
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.033733658 |
| Minimum | 0 |
|---|---|
| Maximum | 15 |
| Zeros | 198466 |
| Zeros (%) | 97.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 15 |
| Range | 15 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.26404323 |
|---|---|
| Coefficient of variation (CV) | 7.8272933 |
| Kurtosis | 591.82119 |
| Mean | 0.033733658 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 16.215274 |
| Sum | 6848 |
| Variance | 0.069718829 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 198466 | |
| 1 | 2697 | 1.3% |
| 2 | 1602 | 0.8% |
| 3 | 165 | 0.1% |
| 4 | 31 | < 0.1% |
| 5 | 17 | < 0.1% |
| 15 | 10 | < 0.1% |
| 7 | 7 | < 0.1% |
| 6 | 6 | < 0.1% |
| 8 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 198466 | |
| 1 | 2697 | 1.3% |
| 2 | 1602 | 0.8% |
| 3 | 165 | 0.1% |
| 4 | 31 | < 0.1% |
| 5 | 17 | < 0.1% |
| 6 | 6 | < 0.1% |
| 7 | 7 | < 0.1% |
| 8 | 1 | < 0.1% |
| 15 | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| 15 | 10 | < 0.1% |
| 8 | 1 | < 0.1% |
| 7 | 7 | < 0.1% |
| 6 | 6 | < 0.1% |
| 5 | 17 | < 0.1% |
| 4 | 31 | < 0.1% |
| 3 | 165 | 0.1% |
| 2 | 1602 | 0.8% |
| 1 | 2697 | 1.3% |
| 0 | 198466 |
numero_noches
Real number (ℝ)
High correlation  Skewed  Zeros 
| Distinct | 42 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.6800278 |
| Minimum | 0 |
|---|---|
| Maximum | 687 |
| Zeros | 101006 |
| Zeros (%) | 49.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 3 |
| 95-th percentile | 6 |
| Maximum | 687 |
| Range | 687 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.866189 |
|---|---|
| Coefficient of variation (CV) | 1.7060367 |
| Kurtosis | 17214.397 |
| Mean | 1.6800278 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 81.018918 |
| Sum | 341049 |
| Variance | 8.2150394 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 101006 | |
| 3 | 38707 | 19.1% |
| 2 | 28782 | 14.2% |
| 4 | 16407 | 8.1% |
| 7 | 8683 | 4.3% |
| 1 | 4702 | 2.3% |
| 5 | 2511 | 1.2% |
| 6 | 1034 | 0.5% |
| 14 | 643 | 0.3% |
| 8 | 142 | 0.1% |
| Other values (32) | 385 | 0.2% |
| Value | Count | Frequency (%) |
| 0 | 101006 | |
| 1 | 4702 | 2.3% |
| 2 | 28782 | 14.2% |
| 3 | 38707 | 19.1% |
| 4 | 16407 | 8.1% |
| 5 | 2511 | 1.2% |
| 6 | 1034 | 0.5% |
| 7 | 8683 | 4.3% |
| 8 | 142 | 0.1% |
| 9 | 67 | < 0.1% |
| Value | Count | Frequency (%) |
| 687 | 1 | < 0.1% |
| 321 | 1 | < 0.1% |
| 191 | 1 | < 0.1% |
| 182 | 3 | |
| 89 | 2 | |
| 87 | 2 | |
| 84 | 1 | < 0.1% |
| 81 | 1 | < 0.1% |
| 74 | 1 | < 0.1% |
| 63 | 2 |
numero_noches_anio_anterior
Real number (ℝ)
High correlation  Skewed  Zeros 
| Distinct | 41 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.6560428 |
| Minimum | 0 |
|---|---|
| Maximum | 687 |
| Zeros | 102402 |
| Zeros (%) | 50.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 3 |
| 95-th percentile | 6 |
| Maximum | 687 |
| Range | 687 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.8479579 |
|---|---|
| Coefficient of variation (CV) | 1.7197369 |
| Kurtosis | 17653.507 |
| Mean | 1.6560428 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 82.306756 |
| Sum | 336180 |
| Variance | 8.1108641 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 102402 | |
| 3 | 38025 | 18.7% |
| 2 | 28423 | 14.0% |
| 4 | 16169 | 8.0% |
| 7 | 8623 | 4.2% |
| 1 | 4696 | 2.3% |
| 5 | 2496 | 1.2% |
| 6 | 1032 | 0.5% |
| 14 | 643 | 0.3% |
| 8 | 140 | 0.1% |
| Other values (31) | 353 | 0.2% |
| Value | Count | Frequency (%) |
| 0 | 102402 | |
| 1 | 4696 | 2.3% |
| 2 | 28423 | 14.0% |
| 3 | 38025 | 18.7% |
| 4 | 16169 | 8.0% |
| 5 | 2496 | 1.2% |
| 6 | 1032 | 0.5% |
| 7 | 8623 | 4.2% |
| 8 | 140 | 0.1% |
| 9 | 67 | < 0.1% |
| Value | Count | Frequency (%) |
| 687 | 1 | < 0.1% |
| 321 | 1 | < 0.1% |
| 191 | 1 | < 0.1% |
| 182 | 3 | |
| 87 | 2 | |
| 84 | 1 | < 0.1% |
| 81 | 1 | < 0.1% |
| 74 | 1 | < 0.1% |
| 63 | 2 | |
| 59 | 1 | < 0.1% |
total_habitaciones
Real number (ℝ)
High correlation  Zeros 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.50558123 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 101049 |
| Zeros (%) | 49.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.50875061 |
|---|---|
| Coefficient of variation (CV) | 1.0062688 |
| Kurtosis | -1.2383857 |
| Mean | 0.50558123 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.1342456 |
| Sum | 102634 |
| Variance | 0.25882718 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 101467 | |
| 0 | 101049 | |
| 2 | 308 | 0.2% |
| 3 | 166 | 0.1% |
| 4 | 8 | < 0.1% |
| 5 | 3 | < 0.1% |
| 6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 101049 | |
| 1 | 101467 | |
| 2 | 308 | 0.2% |
| 3 | 166 | 0.1% |
| 4 | 8 | < 0.1% |
| 5 | 3 | < 0.1% |
| 6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 6 | 1 | < 0.1% |
| 5 | 3 | < 0.1% |
| 4 | 8 | < 0.1% |
| 3 | 166 | 0.1% |
| 2 | 308 | 0.2% |
| 1 | 101467 | |
| 0 | 101049 |
total_habitaciones_anio_anterior
Real number (ℝ)
High correlation  Zeros 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.49858622 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 102445 |
| Zeros (%) | 50.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.50848871 |
|---|---|
| Coefficient of variation (CV) | 1.0198611 |
| Kurtosis | -1.2480827 |
| Mean | 0.49858622 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.15773602 |
| Sum | 101214 |
| Variance | 0.25856077 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 102445 | |
| 1 | 100089 | |
| 2 | 296 | 0.1% |
| 3 | 160 | 0.1% |
| 4 | 8 | < 0.1% |
| 5 | 3 | < 0.1% |
| 6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 102445 | |
| 1 | 100089 | |
| 2 | 296 | 0.1% |
| 3 | 160 | 0.1% |
| 4 | 8 | < 0.1% |
| 5 | 3 | < 0.1% |
| 6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 6 | 1 | < 0.1% |
| 5 | 3 | < 0.1% |
| 4 | 8 | < 0.1% |
| 3 | 160 | 0.1% |
| 2 | 296 | 0.1% |
| 1 | 100089 | |
| 0 | 102445 |
id_programa
Categorical
High correlation  Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 198.5 KiB |
| 1 | |
|---|---|
| 0 | 492 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 202510 | |
| 0 | 492 | 0.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 202510 | |
| 0 | 492 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 202510 | |
| 0 | 492 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 203002 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 202510 | |
| 0 | 492 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 203002 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 202510 | |
| 0 | 492 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 203002 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 202510 | |
| 0 | 492 | 0.2% |
nombre_programa
Categorical
High correlation  Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 198.5 KiB |
| Ninguno | |
|---|---|
| Sin Definir | 492 |
Length
| Max length | 11 |
|---|---|
| Median length | 7 |
| Mean length | 7.0096945 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Ninguno |
|---|---|
| 2nd row | Ninguno |
| 3rd row | Ninguno |
| 4th row | Ninguno |
| 5th row | Ninguno |
Common Values
| Value | Count | Frequency (%) |
| Ninguno | 202510 | |
| Sin Definir | 492 | 0.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| ninguno | 202510 | |
| sin | 492 | 0.2% |
| definir | 492 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 406004 | |
| i | 203986 | |
| N | 202510 | |
| g | 202510 | |
| u | 202510 | |
| o | 202510 | |
| S | 492 | < 0.1% |
| 492 | < 0.1% | |
| D | 492 | < 0.1% |
| e | 492 | < 0.1% |
| Other values (2) | 984 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1422982 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 406004 | |
| i | 203986 | |
| N | 202510 | |
| g | 202510 | |
| u | 202510 | |
| o | 202510 | |
| S | 492 | < 0.1% |
| 492 | < 0.1% | |
| D | 492 | < 0.1% |
| e | 492 | < 0.1% |
| Other values (2) | 984 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1422982 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 406004 | |
| i | 203986 | |
| N | 202510 | |
| g | 202510 | |
| u | 202510 | |
| o | 202510 | |
| S | 492 | < 0.1% |
| 492 | < 0.1% | |
| D | 492 | < 0.1% |
| e | 492 | < 0.1% |
| Other values (2) | 984 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1422982 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 406004 | |
| i | 203986 | |
| N | 202510 | |
| g | 202510 | |
| u | 202510 | |
| o | 202510 | |
| S | 492 | < 0.1% |
| 492 | < 0.1% | |
| D | 492 | < 0.1% |
| e | 492 | < 0.1% |
| Other values (2) | 984 | 0.1% |
id_paquete
Categorical
High correlation  Imbalance 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 198.6 KiB |
| 1 | |
|---|---|
| 2 | |
| 0 | 492 |
| 5 | 92 |
| 3 | 40 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 2 |
| 3rd row | 1 |
| 4th row | 2 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 117658 | |
| 2 | 84718 | |
| 0 | 492 | 0.2% |
| 5 | 92 | < 0.1% |
| 3 | 40 | < 0.1% |
| 4 | 2 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 117658 | |
| 2 | 84718 | |
| 0 | 492 | 0.2% |
| 5 | 92 | < 0.1% |
| 3 | 40 | < 0.1% |
| 4 | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 117658 | |
| 2 | 84718 | |
| 0 | 492 | 0.2% |
| 5 | 92 | < 0.1% |
| 3 | 40 | < 0.1% |
| 4 | 2 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 203002 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 117658 | |
| 2 | 84718 | |
| 0 | 492 | 0.2% |
| 5 | 92 | < 0.1% |
| 3 | 40 | < 0.1% |
| 4 | 2 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 203002 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 117658 | |
| 2 | 84718 | |
| 0 | 492 | 0.2% |
| 5 | 92 | < 0.1% |
| 3 | 40 | < 0.1% |
| 4 | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 203002 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 117658 | |
| 2 | 84718 | |
| 0 | 492 | 0.2% |
| 5 | 92 | < 0.1% |
| 3 | 40 | < 0.1% |
| 4 | 2 | < 0.1% |
nombre_paquete
Categorical
High correlation  Imbalance 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 198.6 KiB |
| Walk In | |
|---|---|
| Ninguno | |
| Sin Definir | 492 |
| Entre Semana | 92 |
| Lunamielero | 40 |
Length
| Max length | 13 |
|---|---|
| Median length | 7 |
| Mean length | 7.0128078 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Walk In |
|---|---|
| 2nd row | Ninguno |
| 3rd row | Walk In |
| 4th row | Ninguno |
| 5th row | Walk In |
Common Values
| Value | Count | Frequency (%) |
| Walk In | 117658 | |
| Ninguno | 84718 | |
| Sin Definir | 492 | 0.2% |
| Entre Semana | 92 | < 0.1% |
| Lunamielero | 40 | < 0.1% |
| Fin De Semana | 2 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| walk | 117658 | |
| in | 117658 | |
| ninguno | 84718 | |
| sin | 492 | 0.2% |
| definir | 492 | 0.2% |
| semana | 94 | < 0.1% |
| entre | 92 | < 0.1% |
| lunamielero | 40 | < 0.1% |
| fin | 2 | < 0.1% |
| de | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 288306 | |
| 118246 | ||
| a | 117886 | |
| l | 117698 | |
| k | 117658 | |
| W | 117658 | |
| I | 117658 | |
| i | 86236 | 6.1% |
| o | 84758 | 6.0% |
| u | 84758 | 6.0% |
| Other values (12) | 172752 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1423614 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 288306 | |
| 118246 | ||
| a | 117886 | |
| l | 117698 | |
| k | 117658 | |
| W | 117658 | |
| I | 117658 | |
| i | 86236 | 6.1% |
| o | 84758 | 6.0% |
| u | 84758 | 6.0% |
| Other values (12) | 172752 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1423614 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 288306 | |
| 118246 | ||
| a | 117886 | |
| l | 117698 | |
| k | 117658 | |
| W | 117658 | |
| I | 117658 | |
| i | 86236 | 6.1% |
| o | 84758 | 6.0% |
| u | 84758 | 6.0% |
| Other values (12) | 172752 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1423614 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 288306 | |
| 118246 | ||
| a | 117886 | |
| l | 117698 | |
| k | 117658 | |
| W | 117658 | |
| I | 117658 | |
| i | 86236 | 6.1% |
| o | 84758 | 6.0% |
| u | 84758 | 6.0% |
| Other values (12) | 172752 |
id_segmento
Categorical
High correlation 
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 199.1 KiB |
| 17 | |
|---|---|
| 14 | |
| 5 | |
| 16 | |
| 12 | |
| Other values (15) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 1.7744702 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 14 |
|---|---|
| 2nd row | 14 |
| 3rd row | 14 |
| 4th row | 14 |
| 5th row | 5 |
Common Values
| Value | Count | Frequency (%) |
| 17 | 73098 | |
| 14 | 27298 | 13.4% |
| 5 | 26874 | 13.2% |
| 16 | 16872 | 8.3% |
| 12 | 15887 | 7.8% |
| 18 | 9082 | 4.5% |
| 1 | 6059 | 3.0% |
| 13 | 5770 | 2.8% |
| 8 | 5195 | 2.6% |
| 10 | 3212 | 1.6% |
| Other values (10) | 13655 | 6.7% |
Length
| Value | Count | Frequency (%) |
| 17 | 73098 | |
| 14 | 27298 | 13.4% |
| 5 | 26874 | 13.2% |
| 16 | 16872 | 8.3% |
| 12 | 15887 | 7.8% |
| 18 | 9082 | 4.5% |
| 1 | 6059 | 3.0% |
| 13 | 5770 | 2.8% |
| 8 | 5195 | 2.6% |
| 10 | 3212 | 1.6% |
| Other values (10) | 13655 | 6.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 166089 | |
| 7 | 75118 | |
| 4 | 27975 | 7.8% |
| 5 | 26878 | 7.5% |
| 6 | 18498 | 5.1% |
| 2 | 15921 | 4.4% |
| 8 | 14277 | 4.0% |
| 9 | 5901 | 1.6% |
| 3 | 5774 | 1.6% |
| 0 | 3790 | 1.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 360221 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 166089 | |
| 7 | 75118 | |
| 4 | 27975 | 7.8% |
| 5 | 26878 | 7.5% |
| 6 | 18498 | 5.1% |
| 2 | 15921 | 4.4% |
| 8 | 14277 | 4.0% |
| 9 | 5901 | 1.6% |
| 3 | 5774 | 1.6% |
| 0 | 3790 | 1.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 360221 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 166089 | |
| 7 | 75118 | |
| 4 | 27975 | 7.8% |
| 5 | 26878 | 7.5% |
| 6 | 18498 | 5.1% |
| 2 | 15921 | 4.4% |
| 8 | 14277 | 4.0% |
| 9 | 5901 | 1.6% |
| 3 | 5774 | 1.6% |
| 0 | 3790 | 1.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 360221 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 166089 | |
| 7 | 75118 | |
| 4 | 27975 | 7.8% |
| 5 | 26878 | 7.5% |
| 6 | 18498 | 5.1% |
| 2 | 15921 | 4.4% |
| 8 | 14277 | 4.0% |
| 9 | 5901 | 1.6% |
| 3 | 5774 | 1.6% |
| 0 | 3790 | 1.1% |
nombre_segmento
Categorical
High correlation 
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 199.1 KiB |
| Tour Operators Domestic | |
|---|---|
| Individual Ep/vac. Club | |
| Ecommerce Ota Domestic | |
| Individual Leisure/package | |
| Gro. & Conv. Meetings | |
| Other values (15) |
Length
| Max length | 29 |
|---|---|
| Median length | 23 |
| Mean length | 23.380341 |
| Min length | 11 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Individual Ep/vac. Club |
|---|---|
| 2nd row | Individual Ep/vac. Club |
| 3rd row | Individual Ep/vac. Club |
| 4th row | Individual Ep/vac. Club |
| 5th row | Ecommerce Ota Domestic |
Common Values
| Value | Count | Frequency (%) |
| Tour Operators Domestic | 73098 | |
| Individual Ep/vac. Club | 27298 | 13.4% |
| Ecommerce Ota Domestic | 26874 | 13.2% |
| Individual Leisure/package | 16872 | 8.3% |
| Gro. & Conv. Meetings | 15887 | 7.8% |
| Tour Operators Internationals | 9082 | 4.5% |
| Complementaries Cortesias | 6059 | 3.0% |
| Individual Business/loyalty | 5770 | 2.8% |
| Ecommerce Website | 5195 | 2.6% |
| Gro. & Conv. Incentive Soc. | 3212 | 1.6% |
| Other values (10) | 13655 | 6.7% |
Length
| Value | Count | Frequency (%) |
| domestic | 99972 | |
| tour | 85365 | |
| operators | 85365 | |
| individual | 49944 | |
| ecommerce | 35715 | 5.9% |
| club | 29318 | 4.8% |
| ota | 28500 | 4.7% |
| ep/vac | 27298 | 4.5% |
| gro | 24626 | 4.1% |
| 24626 | 4.1% | |
| Other values (22) | 114410 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 416470 | 8.8% |
| 402137 | 8.5% | |
| o | 399609 | 8.4% |
| r | 362988 | 7.6% |
| i | 285755 | 6.0% |
| s | 284584 | 6.0% |
| t | 278158 | 5.9% |
| a | 271433 | 5.7% |
| c | 224028 | 4.7% |
| u | 190080 | 4.0% |
| Other values (28) | 1631014 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4746256 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 416470 | 8.8% |
| 402137 | 8.5% | |
| o | 399609 | 8.4% |
| r | 362988 | 7.6% |
| i | 285755 | 6.0% |
| s | 284584 | 6.0% |
| t | 278158 | 5.9% |
| a | 271433 | 5.7% |
| c | 224028 | 4.7% |
| u | 190080 | 4.0% |
| Other values (28) | 1631014 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4746256 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 416470 | 8.8% |
| 402137 | 8.5% | |
| o | 399609 | 8.4% |
| r | 362988 | 7.6% |
| i | 285755 | 6.0% |
| s | 284584 | 6.0% |
| t | 278158 | 5.9% |
| a | 271433 | 5.7% |
| c | 224028 | 4.7% |
| u | 190080 | 4.0% |
| Other values (28) | 1631014 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4746256 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 416470 | 8.8% |
| 402137 | 8.5% | |
| o | 399609 | 8.4% |
| r | 362988 | 7.6% |
| i | 285755 | 6.0% |
| s | 284584 | 6.0% |
| t | 278158 | 5.9% |
| a | 271433 | 5.7% |
| c | 224028 | 4.7% |
| u | 190080 | 4.0% |
| Other values (28) | 1631014 |
id_agencia
Categorical
High cardinality 
| Distinct | 120 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 203.4 KiB |
| 99 | |
|---|---|
| 112 | |
| 86 | |
| 14 | |
| 116 | 8846 |
| Other values (115) |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 2.2083477 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 112 |
|---|---|
| 2nd row | 112 |
| 3rd row | 112 |
| 4th row | 112 |
| 5th row | 14 |
Common Values
| Value | Count | Frequency (%) |
| 99 | 31553 | 15.5% |
| 112 | 25735 | 12.7% |
| 86 | 13031 | 6.4% |
| 14 | 12337 | 6.1% |
| 116 | 8846 | 4.4% |
| 33 | 7596 | 3.7% |
| 93 | 7160 | 3.5% |
| 89 | 6582 | 3.2% |
| 113 | 6337 | 3.1% |
| 32 | 4575 | 2.3% |
| Other values (110) | 79250 |
Length
| Value | Count | Frequency (%) |
| 99 | 31553 | 15.5% |
| 112 | 25735 | 12.7% |
| 86 | 13031 | 6.4% |
| 14 | 12337 | 6.1% |
| 116 | 8846 | 4.4% |
| 33 | 7596 | 3.7% |
| 93 | 7160 | 3.5% |
| 89 | 6582 | 3.2% |
| 113 | 6337 | 3.1% |
| 32 | 4575 | 2.3% |
| Other values (110) | 79250 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 126778 | |
| 9 | 88800 | |
| 2 | 57668 | |
| 3 | 48962 | 10.9% |
| 6 | 36482 | 8.1% |
| 8 | 28336 | 6.3% |
| 4 | 26026 | 5.8% |
| 0 | 12477 | 2.8% |
| 7 | 12359 | 2.8% |
| 5 | 10411 | 2.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 448299 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 126778 | |
| 9 | 88800 | |
| 2 | 57668 | |
| 3 | 48962 | 10.9% |
| 6 | 36482 | 8.1% |
| 8 | 28336 | 6.3% |
| 4 | 26026 | 5.8% |
| 0 | 12477 | 2.8% |
| 7 | 12359 | 2.8% |
| 5 | 10411 | 2.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 448299 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 126778 | |
| 9 | 88800 | |
| 2 | 57668 | |
| 3 | 48962 | 10.9% |
| 6 | 36482 | 8.1% |
| 8 | 28336 | 6.3% |
| 4 | 26026 | 5.8% |
| 0 | 12477 | 2.8% |
| 7 | 12359 | 2.8% |
| 5 | 10411 | 2.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 448299 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 126778 | |
| 9 | 88800 | |
| 2 | 57668 | |
| 3 | 48962 | 10.9% |
| 6 | 36482 | 8.1% |
| 8 | 28336 | 6.3% |
| 4 | 26026 | 5.8% |
| 0 | 12477 | 2.8% |
| 7 | 12359 | 2.8% |
| 5 | 10411 | 2.3% |
nombre_agencia
Categorical
High cardinality 
| Distinct | 112 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 203.3 KiB |
| Hoteles S.a. | |
|---|---|
| Quality Services Morelia | |
| Clientes Particulares | |
| Bestday Travel Group | |
| Sunwing Vacations | 8846 |
| Other values (107) |
Length
| Max length | 50 |
|---|---|
| Median length | 48 |
| Mean length | 20.876479 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Hoteles S.a. |
|---|---|
| 2nd row | Hoteles S.a. |
| 3rd row | Hoteles S.a. |
| 4th row | Hoteles S.a. |
| 5th row | Bestday Travel Group |
Common Values
| Value | Count | Frequency (%) |
| Hoteles S.a. | 42342 | |
| Quality Services Morelia | 31553 | |
| Clientes Particulares | 13031 | 6.4% |
| Bestday Travel Group | 12337 | 6.1% |
| Sunwing Vacations | 8846 | 4.4% |
| Cruz Azul Corporativo | 7596 | 3.7% |
| Quality Services Leon | 7160 | 3.5% |
| Pricetravel Holding | 6582 | 3.2% |
| Operadora De Viajes Solatino | 6337 | 3.1% |
| Quality Services Aguascalientes | 4195 | 2.1% |
| Other values (102) | 63023 |
Length
| Value | Count | Frequency (%) |
| services | 51133 | 8.8% |
| quality | 49167 | 8.4% |
| s.a | 48944 | 8.4% |
| hoteles | 42342 | 7.2% |
| morelia | 37248 | 6.4% |
| de | 26941 | 4.6% |
| group | 17293 | 3.0% |
| travel | 16163 | 2.8% |
| particulares | 13031 | 2.2% |
| clientes | 13031 | 2.2% |
| Other values (247) | 268769 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 455974 | 10.8% |
| 381060 | 9.0% | |
| a | 364207 | 8.6% |
| i | 297220 | 7.0% |
| r | 277984 | 6.6% |
| o | 261207 | 6.2% |
| l | 243489 | 5.7% |
| t | 210255 | 5.0% |
| s | 204322 | 4.8% |
| u | 141851 | 3.3% |
| Other values (57) | 1400398 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4237967 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 455974 | 10.8% |
| 381060 | 9.0% | |
| a | 364207 | 8.6% |
| i | 297220 | 7.0% |
| r | 277984 | 6.6% |
| o | 261207 | 6.2% |
| l | 243489 | 5.7% |
| t | 210255 | 5.0% |
| s | 204322 | 4.8% |
| u | 141851 | 3.3% |
| Other values (57) | 1400398 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4237967 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 455974 | 10.8% |
| 381060 | 9.0% | |
| a | 364207 | 8.6% |
| i | 297220 | 7.0% |
| r | 277984 | 6.6% |
| o | 261207 | 6.2% |
| l | 243489 | 5.7% |
| t | 210255 | 5.0% |
| s | 204322 | 4.8% |
| u | 141851 | 3.3% |
| Other values (57) | 1400398 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4237967 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 455974 | 10.8% |
| 381060 | 9.0% | |
| a | 364207 | 8.6% |
| i | 297220 | 7.0% |
| r | 277984 | 6.6% |
| o | 261207 | 6.2% |
| l | 243489 | 5.7% |
| t | 210255 | 5.0% |
| s | 204322 | 4.8% |
| u | 141851 | 3.3% |
| Other values (57) | 1400398 |
ciudad_agencia
Categorical
High cardinality  High correlation 
| Distinct | 56 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 200.9 KiB |
| Morelia | |
|---|---|
| Mexico City | |
| Ixtapa | |
| Cancún | |
| Toronto | |
| Other values (51) |
Length
| Max length | 15 |
|---|---|
| Median length | 14 |
| Mean length | 8.1781953 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Mexico City |
|---|---|
| 2nd row | Mexico City |
| 3rd row | Mexico City |
| 4th row | Mexico City |
| 5th row | Cancún |
Common Values
| Value | Count | Frequency (%) |
| Morelia | 60055 | |
| Mexico City | 37707 | |
| Ixtapa | 24175 | |
| Cancún | 18919 | 9.3% |
| Toronto | 8846 | 4.4% |
| Del. Coyoacan | 8392 | 4.1% |
| Cancun | 7583 | 3.7% |
| Leon | 6069 | 3.0% |
| Zapopan | 3917 | 1.9% |
| Cd De Mexico | 2458 | 1.2% |
| Other values (46) | 24881 |
Length
| Value | Count | Frequency (%) |
| morelia | 60055 | |
| mexico | 42909 | |
| city | 37733 | |
| ixtapa | 24175 | |
| cancún | 18919 | 7.0% |
| coyoacan | 9308 | 3.5% |
| toronto | 8846 | 3.3% |
| del | 8652 | 3.2% |
| cancun | 7583 | 2.8% |
| de | 6376 | 2.4% |
| Other values (54) | 44114 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 193777 | |
| o | 167958 | 10.1% |
| i | 157340 | 9.5% |
| e | 141709 | 8.5% |
| M | 109373 | 6.6% |
| n | 93606 | 5.6% |
| c | 84015 | 5.1% |
| C | 81939 | 4.9% |
| t | 80242 | 4.8% |
| r | 79335 | 4.8% |
| Other values (41) | 470896 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1660190 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 193777 | |
| o | 167958 | 10.1% |
| i | 157340 | 9.5% |
| e | 141709 | 8.5% |
| M | 109373 | 6.6% |
| n | 93606 | 5.6% |
| c | 84015 | 5.1% |
| C | 81939 | 4.9% |
| t | 80242 | 4.8% |
| r | 79335 | 4.8% |
| Other values (41) | 470896 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1660190 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 193777 | |
| o | 167958 | 10.1% |
| i | 157340 | 9.5% |
| e | 141709 | 8.5% |
| M | 109373 | 6.6% |
| n | 93606 | 5.6% |
| c | 84015 | 5.1% |
| C | 81939 | 4.9% |
| t | 80242 | 4.8% |
| r | 79335 | 4.8% |
| Other values (41) | 470896 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1660190 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 193777 | |
| o | 167958 | 10.1% |
| i | 157340 | 9.5% |
| e | 141709 | 8.5% |
| M | 109373 | 6.6% |
| n | 93606 | 5.6% |
| c | 84015 | 5.1% |
| C | 81939 | 4.9% |
| t | 80242 | 4.8% |
| r | 79335 | 4.8% |
| Other values (41) | 470896 |
entidad_federativa_agencia
Categorical
High correlation 
| Distinct | 23 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 199.1 KiB |
| Michoacán | |
|---|---|
| México | |
| Guerrero | |
| Quintana Roo | |
| Distrito Federal | |
| Other values (18) |
Length
| Max length | 16 |
|---|---|
| Median length | 15 |
| Mean length | 8.731978 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | México |
|---|---|
| 2nd row | México |
| 3rd row | México |
| 4th row | México |
| 5th row | Quintana Roo |
Common Values
| Value | Count | Frequency (%) |
| Michoacán | 62725 | |
| México | 51136 | |
| Guerrero | 28774 | |
| Quintana Roo | 26502 | |
| Distrito Federal | 9442 | 4.7% |
| Ontario | 8868 | 4.4% |
| Guanajuato | 6117 | 3.0% |
| Jalisco | 5394 | 2.7% |
| Querétaro | 1050 | 0.5% |
| Aguascalientes | 1016 | 0.5% |
| Other values (13) | 1978 | 1.0% |
Length
| Value | Count | Frequency (%) |
| michoacán | 62725 | |
| méxico | 51136 | |
| guerrero | 28774 | |
| quintana | 26502 | |
| roo | 26502 | |
| distrito | 9442 | 3.9% |
| federal | 9442 | 3.9% |
| ontario | 8868 | 3.7% |
| guanajuato | 6117 | 2.6% |
| jalisco | 5394 | 2.3% |
| Other values (19) | 4422 | 1.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 228652 | |
| c | 183194 | |
| i | 176871 | 10.0% |
| a | 163076 | 9.2% |
| n | 132854 | 7.5% |
| r | 117344 | 6.6% |
| M | 114239 | 6.4% |
| e | 80236 | 4.5% |
| u | 69874 | 3.9% |
| h | 62845 | 3.5% |
| Other values (30) | 443424 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1772609 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 228652 | |
| c | 183194 | |
| i | 176871 | 10.0% |
| a | 163076 | 9.2% |
| n | 132854 | 7.5% |
| r | 117344 | 6.6% |
| M | 114239 | 6.4% |
| e | 80236 | 4.5% |
| u | 69874 | 3.9% |
| h | 62845 | 3.5% |
| Other values (30) | 443424 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1772609 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 228652 | |
| c | 183194 | |
| i | 176871 | 10.0% |
| a | 163076 | 9.2% |
| n | 132854 | 7.5% |
| r | 117344 | 6.6% |
| M | 114239 | 6.4% |
| e | 80236 | 4.5% |
| u | 69874 | 3.9% |
| h | 62845 | 3.5% |
| Other values (30) | 443424 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1772609 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 228652 | |
| c | 183194 | |
| i | 176871 | 10.0% |
| a | 163076 | 9.2% |
| n | 132854 | 7.5% |
| r | 117344 | 6.6% |
| M | 114239 | 6.4% |
| e | 80236 | 4.5% |
| u | 69874 | 3.9% |
| h | 62845 | 3.5% |
| Other values (30) | 443424 |
pais_agencia
Categorical
High correlation  Imbalance 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 198.6 KiB |
| México | |
|---|---|
| Canada | 8868 |
| Estados Unidos | 1072 |
| Costa Rica | 198 |
| Tarifas | 76 |
Length
| Max length | 14 |
|---|---|
| Median length | 6 |
| Mean length | 6.0465217 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | México |
|---|---|
| 2nd row | México |
| 3rd row | México |
| 4th row | México |
| 5th row | México |
Common Values
| Value | Count | Frequency (%) |
| México | 192788 | |
| Canada | 8868 | 4.4% |
| Estados Unidos | 1072 | 0.5% |
| Costa Rica | 198 | 0.1% |
| Tarifas | 76 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| méxico | 192788 | |
| canada | 8868 | 4.3% |
| estados | 1072 | 0.5% |
| unidos | 1072 | 0.5% |
| costa | 198 | 0.1% |
| rica | 198 | 0.1% |
| tarifas | 76 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 195130 | |
| i | 194134 | |
| c | 192986 | |
| x | 192788 | |
| é | 192788 | |
| M | 192788 | |
| a | 28224 | 2.3% |
| d | 11012 | 0.9% |
| n | 9940 | 0.8% |
| C | 9066 | 0.7% |
| Other values (9) | 8600 | 0.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1227456 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 195130 | |
| i | 194134 | |
| c | 192986 | |
| x | 192788 | |
| é | 192788 | |
| M | 192788 | |
| a | 28224 | 2.3% |
| d | 11012 | 0.9% |
| n | 9940 | 0.8% |
| C | 9066 | 0.7% |
| Other values (9) | 8600 | 0.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1227456 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 195130 | |
| i | 194134 | |
| c | 192986 | |
| x | 192788 | |
| é | 192788 | |
| M | 192788 | |
| a | 28224 | 2.3% |
| d | 11012 | 0.9% |
| n | 9940 | 0.8% |
| C | 9066 | 0.7% |
| Other values (9) | 8600 | 0.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1227456 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 195130 | |
| i | 194134 | |
| c | 192986 | |
| x | 192788 | |
| é | 192788 | |
| M | 192788 | |
| a | 28224 | 2.3% |
| d | 11012 | 0.9% |
| n | 9940 | 0.8% |
| C | 9066 | 0.7% |
| Other values (9) | 8600 | 0.7% |
id_empresa
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 198.5 KiB |
| 1 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 203002 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 203002 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 203002 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 203002 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 203002 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 203002 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 203002 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 203002 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 203002 |
nombre_empresa
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 198.5 KiB |
| Hotel 1 |
|---|
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Hotel 1 |
|---|---|
| 2nd row | Hotel 1 |
| 3rd row | Hotel 1 |
| 4th row | Hotel 1 |
| 5th row | Hotel 1 |
Common Values
| Value | Count | Frequency (%) |
| Hotel 1 | 203002 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| hotel | 203002 | |
| 1 | 203002 |
Most occurring characters
| Value | Count | Frequency (%) |
| H | 203002 | |
| o | 203002 | |
| t | 203002 | |
| e | 203002 | |
| l | 203002 | |
| 203002 | ||
| 1 | 203002 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1421014 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| H | 203002 | |
| o | 203002 | |
| t | 203002 | |
| e | 203002 | |
| l | 203002 | |
| 203002 | ||
| 1 | 203002 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1421014 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| H | 203002 | |
| o | 203002 | |
| t | 203002 | |
| e | 203002 | |
| l | 203002 | |
| 203002 | ||
| 1 | 203002 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1421014 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| H | 203002 | |
| o | 203002 | |
| t | 203002 | |
| e | 203002 | |
| l | 203002 | |
| 203002 | ||
| 1 | 203002 |
total_habitaciones_empresa
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
| 735 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 735 |
|---|---|
| 2nd row | 735 |
| 3rd row | 735 |
| 4th row | 735 |
| 5th row | 735 |
Common Values
| Value | Count | Frequency (%) |
| 735 | 203002 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 735 | 203002 |
Most occurring characters
| Value | Count | Frequency (%) |
| 7 | 203002 | |
| 3 | 203002 | |
| 5 | 203002 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 609006 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 7 | 203002 | |
| 3 | 203002 | |
| 5 | 203002 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 609006 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 7 | 203002 | |
| 3 | 203002 | |
| 5 | 203002 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 609006 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 7 | 203002 | |
| 3 | 203002 | |
| 5 | 203002 |
id_tipo_habitacion
Categorical
High correlation 
| Distinct | 28 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 199.6 KiB |
| 4 | |
|---|---|
| 19 | |
| 17 | |
| 6 | |
| 25 | |
| Other values (23) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 1.6264323 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 25 |
|---|---|
| 2nd row | 25 |
| 3rd row | 23 |
| 4th row | 24 |
| 5th row | 4 |
Common Values
| Value | Count | Frequency (%) |
| 4 | 52796 | |
| 19 | 51281 | |
| 17 | 30868 | |
| 6 | 13910 | 6.9% |
| 25 | 11124 | 5.5% |
| 13 | 10510 | 5.2% |
| 5 | 6091 | 3.0% |
| 23 | 5793 | 2.9% |
| 26 | 4909 | 2.4% |
| 24 | 3849 | 1.9% |
| Other values (18) | 11871 | 5.8% |
Length
| Value | Count | Frequency (%) |
| 4 | 52796 | |
| 19 | 51281 | |
| 17 | 30868 | |
| 6 | 13910 | 6.9% |
| 25 | 11124 | 5.5% |
| 13 | 10510 | 5.2% |
| 5 | 6091 | 3.0% |
| 23 | 5793 | 2.9% |
| 26 | 4909 | 2.4% |
| 24 | 3849 | 1.9% |
| Other values (18) | 11871 | 5.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 98405 | |
| 4 | 56983 | |
| 9 | 51417 | |
| 7 | 34996 | 10.6% |
| 2 | 33669 | 10.2% |
| 6 | 18885 | 5.7% |
| 5 | 17365 | 5.3% |
| 3 | 16493 | 5.0% |
| 8 | 1446 | 0.4% |
| 0 | 510 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 330169 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 98405 | |
| 4 | 56983 | |
| 9 | 51417 | |
| 7 | 34996 | 10.6% |
| 2 | 33669 | 10.2% |
| 6 | 18885 | 5.7% |
| 5 | 17365 | 5.3% |
| 3 | 16493 | 5.0% |
| 8 | 1446 | 0.4% |
| 0 | 510 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 330169 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 98405 | |
| 4 | 56983 | |
| 9 | 51417 | |
| 7 | 34996 | 10.6% |
| 2 | 33669 | 10.2% |
| 6 | 18885 | 5.7% |
| 5 | 17365 | 5.3% |
| 3 | 16493 | 5.0% |
| 8 | 1446 | 0.4% |
| 0 | 510 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 330169 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 98405 | |
| 4 | 56983 | |
| 9 | 51417 | |
| 7 | 34996 | 10.6% |
| 2 | 33669 | 10.2% |
| 6 | 18885 | 5.7% |
| 5 | 17365 | 5.3% |
| 3 | 16493 | 5.0% |
| 8 | 1446 | 0.4% |
| 0 | 510 | 0.2% |
nombre_tipo_habitacion
Categorical
High correlation 
| Distinct | 28 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 199.6 KiB |
| Luxury 2q Sn12gsu | |
|---|---|
| Estd Db Sn12ast | |
| Estd C/balcon Sn12asb | |
| Luxury 1k Sn12gsu | |
| Estd 2q Sn12mst | |
| Other values (23) |
Length
| Max length | 22 |
|---|---|
| Median length | 21 |
| Mean length | 17.6079 |
| Min length | 11 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Estd 2q Sn12mst |
|---|---|
| 2nd row | Estd 2q Sn12mst |
| 3rd row | Jr Suite 1k Sn12mjs |
| 4th row | Jr Suite 2q Sn12mjs |
| 5th row | Luxury 2q Sn12gsu |
Common Values
| Value | Count | Frequency (%) |
| Luxury 2q Sn12gsu | 52796 | |
| Estd Db Sn12ast | 51281 | |
| Estd C/balcon Sn12asb | 30868 | |
| Luxury 1k Sn12gsu | 13910 | 6.9% |
| Estd 2q Sn12mst | 11124 | 5.5% |
| Sup Luj King Sn12asb | 10510 | 5.2% |
| Luxury 2q Sb Sn12gsu | 6091 | 3.0% |
| Jr Suite 1k Sn12mjs | 5793 | 2.9% |
| Mv Luxury 2q Sn12gsu | 4909 | 2.4% |
| Jr Suite 2q Sn12mjs | 3849 | 1.9% |
| Other values (18) | 11871 | 5.8% |
Length
| Value | Count | Frequency (%) |
| estd | 96111 | |
| sn12gsu | 80304 | |
| luxury | 79682 | |
| 2q | 78998 | |
| db | 51805 | |
| sn12ast | 51281 | |
| sn12asb | 43060 | |
| c/balcon | 30868 | 4.8% |
| 1k | 21882 | 3.4% |
| suite | 15729 | 2.4% |
| Other values (28) | 93478 |
Most occurring characters
| Value | Count | Frequency (%) |
| 440196 | 12.3% | |
| s | 303642 | 8.5% |
| 2 | 281990 | 7.9% |
| u | 277429 | 7.8% |
| n | 246696 | 6.9% |
| S | 235266 | 6.6% |
| 1 | 227026 | 6.4% |
| t | 176397 | 4.9% |
| a | 140160 | 3.9% |
| b | 132162 | 3.7% |
| Other values (32) | 1113475 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3574439 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 440196 | 12.3% | |
| s | 303642 | 8.5% |
| 2 | 281990 | 7.9% |
| u | 277429 | 7.8% |
| n | 246696 | 6.9% |
| S | 235266 | 6.6% |
| 1 | 227026 | 6.4% |
| t | 176397 | 4.9% |
| a | 140160 | 3.9% |
| b | 132162 | 3.7% |
| Other values (32) | 1113475 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3574439 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 440196 | 12.3% | |
| s | 303642 | 8.5% |
| 2 | 281990 | 7.9% |
| u | 277429 | 7.8% |
| n | 246696 | 6.9% |
| S | 235266 | 6.6% |
| 1 | 227026 | 6.4% |
| t | 176397 | 4.9% |
| a | 140160 | 3.9% |
| b | 132162 | 3.7% |
| Other values (32) | 1113475 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3574439 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 440196 | 12.3% | |
| s | 303642 | 8.5% |
| 2 | 281990 | 7.9% |
| u | 277429 | 7.8% |
| n | 246696 | 6.9% |
| S | 235266 | 6.6% |
| 1 | 227026 | 6.4% |
| t | 176397 | 4.9% |
| a | 140160 | 3.9% |
| b | 132162 | 3.7% |
| Other values (32) | 1113475 |
cupo_tipo_habitacion
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 10 |
| Missing (%) | < 0.1% |
| Memory size | 1.5 MiB |
| 2.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2.0 |
|---|---|
| 2nd row | 2.0 |
| 3rd row | 2.0 |
| 4th row | 2.0 |
| 5th row | 2.0 |
Common Values
| Value | Count | Frequency (%) |
| 2.0 | 202992 | |
| (Missing) | 10 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2.0 | 202992 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 202992 | |
| . | 202992 | |
| 0 | 202992 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 608976 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 202992 | |
| . | 202992 | |
| 0 | 202992 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 608976 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 202992 | |
| . | 202992 | |
| 0 | 202992 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 608976 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 202992 | |
| . | 202992 | |
| 0 | 202992 |
clasificacion_tipo_habitacion
Categorical
High correlation 
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 10 |
| Missing (%) | < 0.1% |
| Memory size | 198.8 KiB |
| Gsu | |
|---|---|
| Ast | |
| Asb | |
| Mst | |
| Mjs | |
| Other values (6) | 7243 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Mst |
|---|---|
| 2nd row | Mst |
| 3rd row | Mjs |
| 4th row | Mjs |
| 5th row | Gsu |
Common Values
| Value | Count | Frequency (%) |
| Gsu | 80304 | |
| Ast | 51281 | |
| Asb | 43398 | |
| Mst | 11124 | 5.5% |
| Mjs | 9642 | 4.7% |
| Gms | 2152 | 1.1% |
| Ajs | 1808 | 0.9% |
| Afm | 1793 | 0.9% |
| Asd | 1156 | 0.6% |
| Asp | 216 | 0.1% |
Length
| Value | Count | Frequency (%) |
| gsu | 80304 | |
| ast | 51281 | |
| asb | 43398 | |
| mst | 11124 | 5.5% |
| mjs | 9642 | 4.7% |
| gms | 2152 | 1.1% |
| ajs | 1808 | 0.9% |
| afm | 1793 | 0.9% |
| asd | 1156 | 0.6% |
| asp | 216 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 201199 | |
| A | 99652 | |
| G | 82574 | |
| u | 80304 | 13.2% |
| t | 62405 | 10.2% |
| b | 43398 | 7.1% |
| M | 20766 | 3.4% |
| j | 11450 | 1.9% |
| m | 3945 | 0.6% |
| f | 1793 | 0.3% |
| Other values (2) | 1490 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 608976 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| s | 201199 | |
| A | 99652 | |
| G | 82574 | |
| u | 80304 | 13.2% |
| t | 62405 | 10.2% |
| b | 43398 | 7.1% |
| M | 20766 | 3.4% |
| j | 11450 | 1.9% |
| m | 3945 | 0.6% |
| f | 1793 | 0.3% |
| Other values (2) | 1490 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 608976 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| s | 201199 | |
| A | 99652 | |
| G | 82574 | |
| u | 80304 | 13.2% |
| t | 62405 | 10.2% |
| b | 43398 | 7.1% |
| M | 20766 | 3.4% |
| j | 11450 | 1.9% |
| m | 3945 | 0.6% |
| f | 1793 | 0.3% |
| Other values (2) | 1490 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 608976 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| s | 201199 | |
| A | 99652 | |
| G | 82574 | |
| u | 80304 | 13.2% |
| t | 62405 | 10.2% |
| b | 43398 | 7.1% |
| M | 20766 | 3.4% |
| j | 11450 | 1.9% |
| m | 3945 | 0.6% |
| f | 1793 | 0.3% |
| Other values (2) | 1490 | 0.2% |
id_canal
Categorical
High correlation 
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 199.0 KiB |
| 1 | |
|---|---|
| 4 | |
| 10 | |
| 7 | 6805 |
| 0 | 6378 |
| Other values (9) | 6944 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.1086393 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 10 |
|---|---|
| 2nd row | 10 |
| 3rd row | 10 |
| 4th row | 10 |
| 5th row | 13 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 82255 | |
| 4 | 80877 | |
| 10 | 19743 | 9.7% |
| 7 | 6805 | 3.4% |
| 0 | 6378 | 3.1% |
| 8 | 2225 | 1.1% |
| 13 | 1960 | 1.0% |
| 9 | 1092 | 0.5% |
| 5 | 896 | 0.4% |
| 11 | 347 | 0.2% |
| Other values (4) | 424 | 0.2% |
Length
| Value | Count | Frequency (%) |
| 1 | 82255 | |
| 4 | 80877 | |
| 10 | 19743 | 9.7% |
| 7 | 6805 | 3.4% |
| 0 | 6378 | 3.1% |
| 8 | 2225 | 1.1% |
| 13 | 1960 | 1.0% |
| 9 | 1092 | 0.5% |
| 5 | 896 | 0.4% |
| 11 | 347 | 0.2% |
| Other values (4) | 424 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 104656 | |
| 4 | 80877 | |
| 0 | 26121 | 11.6% |
| 7 | 6805 | 3.0% |
| 8 | 2225 | 1.0% |
| 3 | 2120 | 0.9% |
| 9 | 1092 | 0.5% |
| 5 | 896 | 0.4% |
| 2 | 144 | 0.1% |
| 6 | 120 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 225056 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 104656 | |
| 4 | 80877 | |
| 0 | 26121 | 11.6% |
| 7 | 6805 | 3.0% |
| 8 | 2225 | 1.0% |
| 3 | 2120 | 0.9% |
| 9 | 1092 | 0.5% |
| 5 | 896 | 0.4% |
| 2 | 144 | 0.1% |
| 6 | 120 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 225056 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 104656 | |
| 4 | 80877 | |
| 0 | 26121 | 11.6% |
| 7 | 6805 | 3.0% |
| 8 | 2225 | 1.0% |
| 3 | 2120 | 0.9% |
| 9 | 1092 | 0.5% |
| 5 | 896 | 0.4% |
| 2 | 144 | 0.1% |
| 6 | 120 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 225056 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 104656 | |
| 4 | 80877 | |
| 0 | 26121 | 11.6% |
| 7 | 6805 | 3.0% |
| 8 | 2225 | 1.0% |
| 3 | 2120 | 0.9% |
| 9 | 1092 | 0.5% |
| 5 | 896 | 0.4% |
| 2 | 144 | 0.1% |
| 6 | 120 | 0.1% |
nombre_canal
Categorical
High correlation 
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 199.0 KiB |
| Lada 800 Nacional68 | |
|---|---|
| Directo | |
| Multivacaciones 2 | |
| Internet | 6805 |
| Sin Definir | 6378 |
| Other values (9) | 6944 |
Length
| Max length | 22 |
|---|---|
| Median length | 19 |
| Mean length | 13.119925 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Multivacaciones 2 |
|---|---|
| 2nd row | Multivacaciones 2 |
| 3rd row | Multivacaciones 2 |
| 4th row | Multivacaciones 2 |
| 5th row | Vertical Booking |
Common Values
| Value | Count | Frequency (%) |
| Lada 800 Nacional68 | 82255 | |
| Directo | 80877 | |
| Multivacaciones 2 | 19743 | 9.7% |
| Internet | 6805 | 3.4% |
| Sin Definir | 6378 | 3.1% |
| Fax | 2225 | 1.1% |
| Vertical Booking | 1960 | 1.0% |
| Directo Hotel | 1092 | 0.5% |
| Conmutador | 896 | 0.4% |
| Multivacaciones 1 | 347 | 0.2% |
| Other values (4) | 424 | 0.2% |
Length
| Value | Count | Frequency (%) |
| lada | 82555 | |
| 800 | 82555 | |
| nacional68 | 82255 | |
| directo | 81969 | |
| multivacaciones | 20090 | 5.1% |
| 2 | 19743 | 5.0% |
| internet | 6805 | 1.7% |
| sin | 6378 | 1.6% |
| definir | 6378 | 1.6% |
| fax | 2225 | 0.6% |
| Other values (10) | 6683 | 1.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 375481 | |
| i | 227890 | 8.6% |
| c | 206664 | 7.8% |
| 194634 | 7.3% | |
| o | 191550 | 7.2% |
| 0 | 165250 | 6.2% |
| 8 | 164810 | 6.2% |
| n | 132427 | 5.0% |
| e | 125259 | 4.7% |
| t | 119781 | 4.5% |
| Other values (27) | 759625 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2663371 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 375481 | |
| i | 227890 | 8.6% |
| c | 206664 | 7.8% |
| 194634 | 7.3% | |
| o | 191550 | 7.2% |
| 0 | 165250 | 6.2% |
| 8 | 164810 | 6.2% |
| n | 132427 | 5.0% |
| e | 125259 | 4.7% |
| t | 119781 | 4.5% |
| Other values (27) | 759625 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2663371 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 375481 | |
| i | 227890 | 8.6% |
| c | 206664 | 7.8% |
| 194634 | 7.3% | |
| o | 191550 | 7.2% |
| 0 | 165250 | 6.2% |
| 8 | 164810 | 6.2% |
| n | 132427 | 5.0% |
| e | 125259 | 4.7% |
| t | 119781 | 4.5% |
| Other values (27) | 759625 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2663371 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 375481 | |
| i | 227890 | 8.6% |
| c | 206664 | 7.8% |
| 194634 | 7.3% | |
| o | 191550 | 7.2% |
| 0 | 165250 | 6.2% |
| 8 | 164810 | 6.2% |
| n | 132427 | 5.0% |
| e | 125259 | 4.7% |
| t | 119781 | 4.5% |
| Other values (27) | 759625 |
id_pais_origen
Categorical
High correlation  Imbalance 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 198.6 KiB |
| 157 | |
|---|---|
| 0 | 646 |
| 232 | 624 |
| 38 | 228 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.9925124 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 157 |
|---|---|
| 2nd row | 157 |
| 3rd row | 157 |
| 4th row | 157 |
| 5th row | 157 |
Common Values
| Value | Count | Frequency (%) |
| 157 | 201504 | |
| 0 | 646 | 0.3% |
| 232 | 624 | 0.3% |
| 38 | 228 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 157 | 201504 | |
| 0 | 646 | 0.3% |
| 232 | 624 | 0.3% |
| 38 | 228 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 201504 | |
| 5 | 201504 | |
| 7 | 201504 | |
| 2 | 1248 | 0.2% |
| 3 | 852 | 0.1% |
| 0 | 646 | 0.1% |
| 8 | 228 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 607486 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 201504 | |
| 5 | 201504 | |
| 7 | 201504 | |
| 2 | 1248 | 0.2% |
| 3 | 852 | 0.1% |
| 0 | 646 | 0.1% |
| 8 | 228 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 607486 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 201504 | |
| 5 | 201504 | |
| 7 | 201504 | |
| 2 | 1248 | 0.2% |
| 3 | 852 | 0.1% |
| 0 | 646 | 0.1% |
| 8 | 228 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 607486 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 201504 | |
| 5 | 201504 | |
| 7 | 201504 | |
| 2 | 1248 | 0.2% |
| 3 | 852 | 0.1% |
| 0 | 646 | 0.1% |
| 8 | 228 | < 0.1% |
nombre_pais_origen
Categorical
High correlation  Imbalance 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 198.6 KiB |
| Mexico | |
|---|---|
| Sin Definir | 646 |
| United States | 624 |
| Canada | 228 |
Length
| Max length | 13 |
|---|---|
| Median length | 6 |
| Mean length | 6.0374282 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Mexico |
|---|---|
| 2nd row | Mexico |
| 3rd row | Mexico |
| 4th row | Mexico |
| 5th row | Mexico |
Common Values
| Value | Count | Frequency (%) |
| Mexico | 201504 | |
| Sin Definir | 646 | 0.3% |
| United States | 624 | 0.3% |
| Canada | 228 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| mexico | 201504 | |
| sin | 646 | 0.3% |
| definir | 646 | 0.3% |
| united | 624 | 0.3% |
| states | 624 | 0.3% |
| canada | 228 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 204066 | |
| e | 203398 | |
| M | 201504 | |
| x | 201504 | |
| c | 201504 | |
| o | 201504 | |
| n | 2144 | 0.2% |
| t | 1872 | 0.2% |
| a | 1308 | 0.1% |
| S | 1270 | 0.1% |
| Other values (8) | 5536 | 0.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1225610 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 204066 | |
| e | 203398 | |
| M | 201504 | |
| x | 201504 | |
| c | 201504 | |
| o | 201504 | |
| n | 2144 | 0.2% |
| t | 1872 | 0.2% |
| a | 1308 | 0.1% |
| S | 1270 | 0.1% |
| Other values (8) | 5536 | 0.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1225610 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 204066 | |
| e | 203398 | |
| M | 201504 | |
| x | 201504 | |
| c | 201504 | |
| o | 201504 | |
| n | 2144 | 0.2% |
| t | 1872 | 0.2% |
| a | 1308 | 0.1% |
| S | 1270 | 0.1% |
| Other values (8) | 5536 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1225610 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 204066 | |
| e | 203398 | |
| M | 201504 | |
| x | 201504 | |
| c | 201504 | |
| o | 201504 | |
| n | 2144 | 0.2% |
| t | 1872 | 0.2% |
| a | 1308 | 0.1% |
| S | 1270 | 0.1% |
| Other values (8) | 5536 | 0.5% |
reservacion_pendiente
Boolean
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 198.4 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 102199 | |
| False | 100803 |
id_estatus_reservacion
Categorical
High correlation 
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 198.7 KiB |
| 9 | |
|---|---|
| 2 | |
| 5 | |
| 1 | |
| 3 | 1854 |
| Other values (3) | 740 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 9 |
|---|---|
| 2nd row | 9 |
| 3rd row | 9 |
| 4th row | 9 |
| 5th row | 9 |
Common Values
| Value | Count | Frequency (%) |
| 9 | 131069 | |
| 2 | 33301 | 16.4% |
| 5 | 18880 | 9.3% |
| 1 | 17158 | 8.5% |
| 3 | 1854 | 0.9% |
| 4 | 586 | 0.3% |
| 8 | 130 | 0.1% |
| 7 | 24 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 9 | 131069 | |
| 2 | 33301 | 16.4% |
| 5 | 18880 | 9.3% |
| 1 | 17158 | 8.5% |
| 3 | 1854 | 0.9% |
| 4 | 586 | 0.3% |
| 8 | 130 | 0.1% |
| 7 | 24 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 9 | 131069 | |
| 2 | 33301 | 16.4% |
| 5 | 18880 | 9.3% |
| 1 | 17158 | 8.5% |
| 3 | 1854 | 0.9% |
| 4 | 586 | 0.3% |
| 8 | 130 | 0.1% |
| 7 | 24 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 203002 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 9 | 131069 | |
| 2 | 33301 | 16.4% |
| 5 | 18880 | 9.3% |
| 1 | 17158 | 8.5% |
| 3 | 1854 | 0.9% |
| 4 | 586 | 0.3% |
| 8 | 130 | 0.1% |
| 7 | 24 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 203002 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 9 | 131069 | |
| 2 | 33301 | 16.4% |
| 5 | 18880 | 9.3% |
| 1 | 17158 | 8.5% |
| 3 | 1854 | 0.9% |
| 4 | 586 | 0.3% |
| 8 | 130 | 0.1% |
| 7 | 24 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 203002 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 9 | 131069 | |
| 2 | 33301 | 16.4% |
| 5 | 18880 | 9.3% |
| 1 | 17158 | 8.5% |
| 3 | 1854 | 0.9% |
| 4 | 586 | 0.3% |
| 8 | 130 | 0.1% |
| 7 | 24 | < 0.1% |
nombre_estatus_reservacion
Categorical
High correlation 
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 198.7 KiB |
| Salida | |
|---|---|
| Reservacion Cancelada | |
| Rooming List | |
| Reservacion O (r)registro | |
| No Show | 1854 |
| Other values (3) | 740 |
Length
| Max length | 25 |
|---|---|
| Median length | 6 |
| Mean length | 10.696826 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Salida |
|---|---|
| 2nd row | Salida |
| 3rd row | Salida |
| 4th row | Salida |
| 5th row | Salida |
Common Values
| Value | Count | Frequency (%) |
| Salida | 131069 | |
| Reservacion Cancelada | 33301 | 16.4% |
| Rooming List | 18880 | 9.3% |
| Reservacion O (r)registro | 17158 | 8.5% |
| No Show | 1854 | 0.9% |
| Reservacion En Transicion | 586 | 0.3% |
| En Casa (registro) | 130 | 0.1% |
| Preregistro | 24 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| salida | 131069 | |
| reservacion | 51045 | 17.4% |
| cancelada | 33301 | 11.4% |
| rooming | 18880 | 6.4% |
| list | 18880 | 6.4% |
| o | 17158 | 5.9% |
| r)registro | 17158 | 5.9% |
| no | 1854 | 0.6% |
| show | 1854 | 0.6% |
| en | 716 | 0.2% |
| Other values (4) | 870 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 413932 | |
| i | 238358 | |
| l | 164370 | 7.6% |
| d | 164370 | 7.6% |
| e | 152727 | 7.0% |
| S | 132923 | 6.1% |
| o | 110411 | 5.1% |
| n | 105114 | 4.8% |
| r | 103437 | 4.8% |
| 89783 | 4.1% | |
| Other values (18) | 496052 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2171477 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 413932 | |
| i | 238358 | |
| l | 164370 | 7.6% |
| d | 164370 | 7.6% |
| e | 152727 | 7.0% |
| S | 132923 | 6.1% |
| o | 110411 | 5.1% |
| n | 105114 | 4.8% |
| r | 103437 | 4.8% |
| 89783 | 4.1% | |
| Other values (18) | 496052 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2171477 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 413932 | |
| i | 238358 | |
| l | 164370 | 7.6% |
| d | 164370 | 7.6% |
| e | 152727 | 7.0% |
| S | 132923 | 6.1% |
| o | 110411 | 5.1% |
| n | 105114 | 4.8% |
| r | 103437 | 4.8% |
| 89783 | 4.1% | |
| Other values (18) | 496052 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2171477 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 413932 | |
| i | 238358 | |
| l | 164370 | 7.6% |
| d | 164370 | 7.6% |
| e | 152727 | 7.0% |
| S | 132923 | 6.1% |
| o | 110411 | 5.1% |
| n | 105114 | 4.8% |
| r | 103437 | 4.8% |
| 89783 | 4.1% | |
| Other values (18) | 496052 |
clave_estado
Categorical
High cardinality  Imbalance 
| Distinct | 148 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 401.8 KiB |
| Egr | |
|---|---|
| Emc | |
| Emx | |
| Egt | |
| Edf | |
| Other values (143) |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.0177831 |
| Min length | 0 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Emx |
|---|---|
| 2nd row | Egt |
| 3rd row | Emc |
| 4th row | Egt |
| 5th row | Emx |
Common Values
| Value | Count | Frequency (%) |
| Egr | 62426 | |
| Emc | 55473 | |
| Emx | 18770 | 9.2% |
| Egt | 17465 | 8.6% |
| Edf | 9142 | 4.5% |
| Eqe | 5596 | 2.8% |
| Ehg | 5317 | 2.6% |
| Eagu | 3164 | 1.6% |
| Eqr | 2775 | 1.4% |
| Eca | 2613 | 1.3% |
| Other values (138) | 20261 | 10.0% |
Length
| Value | Count | Frequency (%) |
| egr | 62426 | |
| emc | 55473 | |
| emx | 18770 | 9.2% |
| egt | 17465 | 8.6% |
| edf | 9142 | 4.5% |
| eqe | 5596 | 2.8% |
| ehg | 5317 | 2.6% |
| eagu | 3164 | 1.6% |
| eqr | 2775 | 1.4% |
| eca | 2613 | 1.3% |
| Other values (137) | 20259 | 10.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 203000 | |
| g | 88648 | |
| m | 75932 | 12.4% |
| r | 65819 | 10.7% |
| c | 61412 | 10.0% |
| x | 19154 | 3.1% |
| t | 18511 | 3.0% |
| a | 11317 | 1.8% |
| d | 9316 | 1.5% |
| f | 9276 | 1.5% |
| Other values (21) | 50231 | 8.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 612616 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 203000 | |
| g | 88648 | |
| m | 75932 | 12.4% |
| r | 65819 | 10.7% |
| c | 61412 | 10.0% |
| x | 19154 | 3.1% |
| t | 18511 | 3.0% |
| a | 11317 | 1.8% |
| d | 9316 | 1.5% |
| f | 9276 | 1.5% |
| Other values (21) | 50231 | 8.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 612616 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 203000 | |
| g | 88648 | |
| m | 75932 | 12.4% |
| r | 65819 | 10.7% |
| c | 61412 | 10.0% |
| x | 19154 | 3.1% |
| t | 18511 | 3.0% |
| a | 11317 | 1.8% |
| d | 9316 | 1.5% |
| f | 9276 | 1.5% |
| Other values (21) | 50231 | 8.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 612616 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 203000 | |
| g | 88648 | |
| m | 75932 | 12.4% |
| r | 65819 | 10.7% |
| c | 61412 | 10.0% |
| x | 19154 | 3.1% |
| t | 18511 | 3.0% |
| a | 11317 | 1.8% |
| d | 9316 | 1.5% |
| f | 9276 | 1.5% |
| Other values (21) | 50231 | 8.2% |
nombre_estado
Categorical
High cardinality  Imbalance 
| Distinct | 144 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 401.8 KiB |
| Guerrero | |
|---|---|
| Michoacán | |
| México | |
| Guanajuato | |
| Distrito Federal | |
| Other values (139) |
Length
| Max length | 30 |
|---|---|
| Median length | 27 |
| Mean length | 8.9514631 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | México |
|---|---|
| 2nd row | Guanajuato |
| 3rd row | Michoacán |
| 4th row | Guanajuato |
| 5th row | México |
Common Values
| Value | Count | Frequency (%) |
| Guerrero | 62426 | |
| Michoacán | 55473 | |
| México | 18770 | 9.2% |
| Guanajuato | 17465 | 8.6% |
| Distrito Federal | 9142 | 4.5% |
| Querétaro | 5596 | 2.8% |
| Hidalgo | 5317 | 2.6% |
| Aguascalientes | 3164 | 1.6% |
| Quintana Roo | 2775 | 1.4% |
| California | 2613 | 1.3% |
| Other values (134) | 20259 | 10.0% |
Length
| Value | Count | Frequency (%) |
| guerrero | 62426 | |
| michoacán | 55473 | |
| méxico | 18770 | 8.4% |
| guanajuato | 17465 | 7.8% |
| distrito | 9152 | 4.1% |
| federal | 9142 | 4.1% |
| querétaro | 5596 | 2.5% |
| hidalgo | 5317 | 2.4% |
| aguascalientes | 3164 | 1.4% |
| quintana | 2775 | 1.2% |
| Other values (173) | 33406 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 228601 | |
| o | 198703 | |
| a | 169367 | 9.3% |
| e | 163094 | 9.0% |
| c | 137622 | 7.6% |
| i | 127571 | 7.0% |
| u | 117554 | 6.5% |
| n | 94244 | 5.2% |
| G | 80121 | 4.4% |
| M | 75826 | 4.2% |
| Other values (47) | 424444 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1817147 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 228601 | |
| o | 198703 | |
| a | 169367 | 9.3% |
| e | 163094 | 9.0% |
| c | 137622 | 7.6% |
| i | 127571 | 7.0% |
| u | 117554 | 6.5% |
| n | 94244 | 5.2% |
| G | 80121 | 4.4% |
| M | 75826 | 4.2% |
| Other values (47) | 424444 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1817147 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 228601 | |
| o | 198703 | |
| a | 169367 | 9.3% |
| e | 163094 | 9.0% |
| c | 137622 | 7.6% |
| i | 127571 | 7.0% |
| u | 117554 | 6.5% |
| n | 94244 | 5.2% |
| G | 80121 | 4.4% |
| M | 75826 | 4.2% |
| Other values (47) | 424444 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1817147 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 228601 | |
| o | 198703 | |
| a | 169367 | 9.3% |
| e | 163094 | 9.0% |
| c | 137622 | 7.6% |
| i | 127571 | 7.0% |
| u | 117554 | 6.5% |
| n | 94244 | 5.2% |
| G | 80121 | 4.4% |
| M | 75826 | 4.2% |
| Other values (47) | 424444 |
total_tarifa
Real number (ℝ)
High correlation  Skewed  Zeros 
| Distinct | 11596 |
|---|---|
| Distinct (%) | 5.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4106.7283 |
| Minimum | -30910 |
|---|---|
| Maximum | 1033056 |
| Zeros | 106391 |
| Zeros (%) | 52.4% |
| Negative | 33 |
| Negative (%) | < 0.1% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | -30910 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 7592 |
| 95-th percentile | 14720 |
| Maximum | 1033056 |
| Range | 1063966 |
| Interquartile range (IQR) | 7592 |
Descriptive statistics
| Standard deviation | 6501.7072 |
|---|---|
| Coefficient of variation (CV) | 1.5831841 |
| Kurtosis | 3619.6509 |
| Mean | 4106.7283 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 26.894022 |
| Sum | 8.3367407 × 108 |
| Variance | 42272197 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 106391 | |
| 5392 | 1474 | 0.7% |
| 7236 | 1283 | 0.6% |
| 8088 | 900 | 0.4% |
| 7662 | 870 | 0.4% |
| 7960 | 859 | 0.4% |
| 8514 | 803 | 0.4% |
| 5108 | 800 | 0.4% |
| 6810 | 796 | 0.4% |
| 7878 | 635 | 0.3% |
| Other values (11586) | 88191 |
| Value | Count | Frequency (%) |
| -30910 | 7 | < 0.1% |
| -29950 | 1 | < 0.1% |
| -20000 | 7 | < 0.1% |
| -3087 | 16 | < 0.1% |
| -1345.6 | 1 | < 0.1% |
| -3 | 1 | < 0.1% |
| 0 | 106391 | |
| 0.08 | 3 | < 0.1% |
| 0.09 | 2 | < 0.1% |
| 0.14 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 1033056 | 1 | < 0.1% |
| 655848 | 1 | < 0.1% |
| 268632 | 1 | < 0.1% |
| 201474 | 1 | < 0.1% |
| 166296 | 1 | < 0.1% |
| 145544 | 1 | < 0.1% |
| 132946.8 | 7 | |
| 122500 | 1 | < 0.1% |
| 105000 | 1 | < 0.1% |
| 102816 | 1 | < 0.1% |
id_moneda
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 198.5 KiB |
| 1 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 203002 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 203002 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 203002 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 203002 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 203002 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 203002 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 203002 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 203002 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 203002 |
| Distinct | 520 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 497 |
| Missing (%) | 0.2% |
| Memory size | 1.5 MiB |
| Minimum | 2019-01-02 00:00:00 |
|---|---|
| Maximum | 2020-12-07 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
reservacion
Boolean
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 198.4 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 102199 | |
| False | 100803 |
reservacion_anio_anterior
Boolean
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 198.4 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 102199 | |
| True | 100803 |
id_cliente_disp
Categorical
High correlation  Imbalance 
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 199.0 KiB |
| 0 | |
|---|---|
| 2 | |
| 3 | |
| 1 | 5654 |
| 4 | 2962 |
| Other values (11) | 1272 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.0004433 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 4 |
| 3rd row | 2 |
| 4th row | 3 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 100803 | |
| 2 | 80295 | |
| 3 | 12016 | 5.9% |
| 1 | 5654 | 2.8% |
| 4 | 2962 | 1.5% |
| 5 | 536 | 0.3% |
| 6 | 427 | 0.2% |
| 8 | 156 | 0.1% |
| 7 | 43 | < 0.1% |
| 15 | 24 | < 0.1% |
| Other values (6) | 86 | < 0.1% |
Length
| Value | Count | Frequency (%) |
| 0 | 100803 | |
| 2 | 80295 | |
| 3 | 12016 | 5.9% |
| 1 | 5654 | 2.8% |
| 4 | 2962 | 1.5% |
| 5 | 536 | 0.3% |
| 6 | 427 | 0.2% |
| 8 | 156 | 0.1% |
| 7 | 43 | < 0.1% |
| 15 | 24 | < 0.1% |
| Other values (6) | 86 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 100826 | |
| 2 | 80317 | |
| 3 | 12020 | 5.9% |
| 1 | 5753 | 2.8% |
| 4 | 2970 | 1.5% |
| 5 | 560 | 0.3% |
| 6 | 427 | 0.2% |
| 8 | 156 | 0.1% |
| 7 | 43 | < 0.1% |
| 9 | 20 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 203092 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 100826 | |
| 2 | 80317 | |
| 3 | 12020 | 5.9% |
| 1 | 5753 | 2.8% |
| 4 | 2970 | 1.5% |
| 5 | 560 | 0.3% |
| 6 | 427 | 0.2% |
| 8 | 156 | 0.1% |
| 7 | 43 | < 0.1% |
| 9 | 20 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 203092 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 100826 | |
| 2 | 80317 | |
| 3 | 12020 | 5.9% |
| 1 | 5753 | 2.8% |
| 4 | 2970 | 1.5% |
| 5 | 560 | 0.3% |
| 6 | 427 | 0.2% |
| 8 | 156 | 0.1% |
| 7 | 43 | < 0.1% |
| 9 | 20 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 203092 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 100826 | |
| 2 | 80317 | |
| 3 | 12020 | 5.9% |
| 1 | 5753 | 2.8% |
| 4 | 2970 | 1.5% |
| 5 | 560 | 0.3% |
| 6 | 427 | 0.2% |
| 8 | 156 | 0.1% |
| 7 | 43 | < 0.1% |
| 9 | 20 | < 0.1% |
cliente_disp_anio_anterior
Real number (ℝ)
High correlation  Zeros 
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.0796938 |
| Minimum | 0 |
|---|---|
| Maximum | 15 |
| Zeros | 102199 |
| Zeros (%) | 50.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 15 |
| Range | 15 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.2046937 |
|---|---|
| Coefficient of variation (CV) | 1.1157735 |
| Kurtosis | 4.2151962 |
| Mean | 1.0796938 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.0595136 |
| Sum | 219180 |
| Variance | 1.451287 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 102199 | |
| 2 | 79038 | |
| 3 | 11946 | 5.9% |
| 1 | 5638 | 2.8% |
| 4 | 2933 | 1.4% |
| 5 | 534 | 0.3% |
| 6 | 422 | 0.2% |
| 8 | 143 | 0.1% |
| 7 | 43 | < 0.1% |
| 10 | 23 | < 0.1% |
| Other values (6) | 83 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 102199 | |
| 1 | 5638 | 2.8% |
| 2 | 79038 | |
| 3 | 11946 | 5.9% |
| 4 | 2933 | 1.4% |
| 5 | 534 | 0.3% |
| 6 | 422 | 0.2% |
| 7 | 43 | < 0.1% |
| 8 | 143 | 0.1% |
| 9 | 19 | < 0.1% |
| Value | Count | Frequency (%) |
| 15 | 23 | < 0.1% |
| 14 | 8 | < 0.1% |
| 13 | 4 | < 0.1% |
| 12 | 20 | < 0.1% |
| 11 | 9 | < 0.1% |
| 10 | 23 | < 0.1% |
| 9 | 19 | < 0.1% |
| 8 | 143 | 0.1% |
| 7 | 43 | < 0.1% |
| 6 | 422 |
Interactions
Correlations
| ciudad_agencia | clasificacion_tipo_habitacion | cliente_disp_anio_anterior | entidad_federativa_agencia | id_canal | id_cliente_disp | id_estatus_reservacion | id_pais_origen | id_paquete | id_programa | id_reservaciones | id_segmento | id_tipo_habitacion | nombre_canal | nombre_estatus_reservacion | nombre_pais_origen | nombre_paquete | nombre_programa | nombre_segmento | nombre_tipo_habitacion | numero_adultos | numero_adultos_anio_anterior | numero_menores | numero_menores_anio_anterior | numero_noches | numero_noches_anio_anterior | numero_personas | numero_personas_anio_anterior | pais_agencia | reservacion | reservacion_anio_anterior | reservacion_pendiente | total_habitaciones | total_habitaciones_anio_anterior | total_tarifa | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ciudad_agencia | 1.000 | 0.227 | 0.097 | 0.996 | 0.332 | 0.086 | 0.202 | 0.128 | 0.333 | 0.418 | 0.128 | 0.552 | 0.161 | 0.332 | 0.202 | 0.128 | 0.333 | 0.418 | 0.552 | 0.161 | 0.098 | 0.097 | 0.023 | 0.023 | 0.000 | 0.000 | 0.091 | 0.090 | 1.000 | 0.000 | 0.000 | 0.000 | 0.039 | 0.038 | 0.000 |
| clasificacion_tipo_habitacion | 0.227 | 1.000 | 0.111 | 0.182 | 0.210 | 0.113 | 0.168 | 0.024 | 0.042 | 0.059 | 0.059 | 0.252 | 1.000 | 0.210 | 0.168 | 0.024 | 0.042 | 0.059 | 0.252 | 1.000 | 0.112 | 0.111 | 0.032 | 0.032 | 0.000 | 0.000 | 0.107 | 0.107 | 0.058 | 0.000 | 0.000 | 0.000 | 0.046 | 0.046 | 0.015 |
| cliente_disp_anio_anterior | 0.097 | 0.111 | 1.000 | 0.080 | 0.083 | 0.315 | 0.035 | 0.000 | 0.019 | 0.005 | 0.833 | 0.104 | 0.117 | 0.083 | 0.035 | 0.000 | 0.019 | 0.005 | 0.104 | 0.117 | -0.921 | 1.000 | -0.145 | 0.170 | -0.892 | 0.901 | -0.911 | 0.982 | 0.020 | 0.946 | 0.946 | 0.946 | -0.957 | 0.958 | -0.849 |
| entidad_federativa_agencia | 0.996 | 0.182 | 0.080 | 1.000 | 0.275 | 0.071 | 0.142 | 0.122 | 0.241 | 0.112 | 0.082 | 0.440 | 0.143 | 0.275 | 0.142 | 0.122 | 0.241 | 0.112 | 0.440 | 0.143 | 0.081 | 0.080 | 0.017 | 0.017 | 0.000 | 0.000 | 0.071 | 0.071 | 1.000 | 0.000 | 0.000 | 0.000 | 0.033 | 0.032 | 0.000 |
| id_canal | 0.332 | 0.210 | 0.083 | 0.275 | 1.000 | 0.077 | 0.208 | 0.182 | 0.356 | 0.274 | 0.080 | 0.351 | 0.215 | 1.000 | 0.208 | 0.182 | 0.356 | 0.274 | 0.351 | 0.215 | 0.083 | 0.083 | 0.037 | 0.036 | 0.000 | 0.000 | 0.085 | 0.085 | 0.181 | 0.000 | 0.000 | 0.000 | 0.045 | 0.044 | 0.003 |
| id_cliente_disp | 0.086 | 0.113 | 0.315 | 0.071 | 0.077 | 1.000 | 0.068 | 0.005 | 0.031 | 0.016 | 0.333 | 0.091 | 0.102 | 0.077 | 0.068 | 0.005 | 0.031 | 0.016 | 0.091 | 0.102 | 1.000 | 0.315 | 0.377 | 0.038 | 0.011 | 0.000 | 0.647 | 0.087 | 0.036 | 1.000 | 1.000 | 1.000 | 0.421 | 0.407 | 0.000 |
| id_estatus_reservacion | 0.202 | 0.168 | 0.035 | 0.142 | 0.208 | 0.068 | 1.000 | 0.052 | 0.180 | 0.154 | 0.175 | 0.177 | 0.188 | 0.208 | 1.000 | 0.052 | 0.180 | 0.154 | 0.177 | 0.188 | 0.039 | 0.035 | 0.030 | 0.030 | 0.000 | 0.002 | 0.042 | 0.042 | 0.062 | 0.017 | 0.017 | 0.017 | 0.039 | 0.038 | 0.027 |
| id_pais_origen | 0.128 | 0.024 | 0.000 | 0.122 | 0.182 | 0.005 | 0.052 | 1.000 | 0.034 | 0.002 | 0.032 | 0.122 | 0.032 | 0.182 | 0.052 | 1.000 | 0.034 | 0.002 | 0.122 | 0.032 | 0.000 | 0.000 | 0.000 | 0.000 | 0.007 | 0.000 | 0.004 | 0.004 | 0.092 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| id_paquete | 0.333 | 0.042 | 0.019 | 0.241 | 0.356 | 0.031 | 0.180 | 0.034 | 1.000 | 1.000 | 0.045 | 0.293 | 0.065 | 0.356 | 0.180 | 0.034 | 1.000 | 1.000 | 0.293 | 0.065 | 0.019 | 0.019 | 0.018 | 0.018 | 0.000 | 0.000 | 0.021 | 0.021 | 0.088 | 0.000 | 0.000 | 0.000 | 0.028 | 0.027 | 0.000 |
| id_programa | 0.418 | 0.059 | 0.005 | 0.112 | 0.274 | 0.016 | 0.154 | 0.002 | 1.000 | 1.000 | 0.057 | 0.157 | 0.066 | 0.274 | 0.154 | 0.002 | 1.000 | 0.999 | 0.157 | 0.066 | 0.004 | 0.005 | 0.000 | 0.000 | 0.000 | 0.000 | 0.010 | 0.010 | 0.010 | 0.000 | 0.000 | 0.000 | 0.049 | 0.049 | 0.000 |
| id_reservaciones | 0.128 | 0.059 | 0.833 | 0.082 | 0.080 | 0.333 | 0.175 | 0.032 | 0.045 | 0.057 | 1.000 | 0.080 | 0.066 | 0.080 | 0.175 | 0.032 | 0.045 | 0.057 | 0.080 | 0.066 | -0.829 | 0.833 | -0.143 | 0.119 | -0.812 | 0.799 | -0.817 | 0.829 | 0.062 | 0.993 | 0.993 | 0.993 | -0.864 | 0.862 | -0.767 |
| id_segmento | 0.552 | 0.252 | 0.104 | 0.440 | 0.351 | 0.091 | 0.177 | 0.122 | 0.293 | 0.157 | 0.080 | 1.000 | 0.212 | 0.351 | 0.177 | 0.122 | 0.293 | 0.157 | 1.000 | 0.212 | 0.106 | 0.104 | 0.032 | 0.032 | 0.031 | 0.028 | 0.104 | 0.103 | 0.501 | 0.000 | 0.000 | 0.000 | 0.050 | 0.049 | 0.008 |
| id_tipo_habitacion | 0.161 | 1.000 | 0.117 | 0.143 | 0.215 | 0.102 | 0.188 | 0.032 | 0.065 | 0.066 | 0.066 | 0.212 | 1.000 | 0.215 | 0.188 | 0.032 | 0.065 | 0.066 | 0.212 | 1.000 | 0.118 | 0.117 | 0.037 | 0.037 | 0.055 | 0.054 | 0.115 | 0.114 | 0.081 | 0.000 | 0.000 | 0.000 | 0.055 | 0.054 | 0.014 |
| nombre_canal | 0.332 | 0.210 | 0.083 | 0.275 | 1.000 | 0.077 | 0.208 | 0.182 | 0.356 | 0.274 | 0.080 | 0.351 | 0.215 | 1.000 | 0.208 | 0.182 | 0.356 | 0.274 | 0.351 | 0.215 | 0.083 | 0.083 | 0.037 | 0.036 | 0.000 | 0.000 | 0.085 | 0.085 | 0.181 | 0.000 | 0.000 | 0.000 | 0.045 | 0.044 | 0.003 |
| nombre_estatus_reservacion | 0.202 | 0.168 | 0.035 | 0.142 | 0.208 | 0.068 | 1.000 | 0.052 | 0.180 | 0.154 | 0.175 | 0.177 | 0.188 | 0.208 | 1.000 | 0.052 | 0.180 | 0.154 | 0.177 | 0.188 | 0.039 | 0.035 | 0.030 | 0.030 | 0.000 | 0.002 | 0.042 | 0.042 | 0.062 | 0.017 | 0.017 | 0.017 | 0.039 | 0.038 | 0.027 |
| nombre_pais_origen | 0.128 | 0.024 | 0.000 | 0.122 | 0.182 | 0.005 | 0.052 | 1.000 | 0.034 | 0.002 | 0.032 | 0.122 | 0.032 | 0.182 | 0.052 | 1.000 | 0.034 | 0.002 | 0.122 | 0.032 | 0.000 | 0.000 | 0.000 | 0.000 | 0.007 | 0.000 | 0.004 | 0.004 | 0.092 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| nombre_paquete | 0.333 | 0.042 | 0.019 | 0.241 | 0.356 | 0.031 | 0.180 | 0.034 | 1.000 | 1.000 | 0.045 | 0.293 | 0.065 | 0.356 | 0.180 | 0.034 | 1.000 | 1.000 | 0.293 | 0.065 | 0.019 | 0.019 | 0.018 | 0.018 | 0.000 | 0.000 | 0.021 | 0.021 | 0.088 | 0.000 | 0.000 | 0.000 | 0.028 | 0.027 | 0.000 |
| nombre_programa | 0.418 | 0.059 | 0.005 | 0.112 | 0.274 | 0.016 | 0.154 | 0.002 | 1.000 | 0.999 | 0.057 | 0.157 | 0.066 | 0.274 | 0.154 | 0.002 | 1.000 | 1.000 | 0.157 | 0.066 | 0.004 | 0.005 | 0.000 | 0.000 | 0.000 | 0.000 | 0.010 | 0.010 | 0.010 | 0.000 | 0.000 | 0.000 | 0.049 | 0.049 | 0.000 |
| nombre_segmento | 0.552 | 0.252 | 0.104 | 0.440 | 0.351 | 0.091 | 0.177 | 0.122 | 0.293 | 0.157 | 0.080 | 1.000 | 0.212 | 0.351 | 0.177 | 0.122 | 0.293 | 0.157 | 1.000 | 0.212 | 0.106 | 0.104 | 0.032 | 0.032 | 0.031 | 0.028 | 0.104 | 0.103 | 0.501 | 0.000 | 0.000 | 0.000 | 0.050 | 0.049 | 0.008 |
| nombre_tipo_habitacion | 0.161 | 1.000 | 0.117 | 0.143 | 0.215 | 0.102 | 0.188 | 0.032 | 0.065 | 0.066 | 0.066 | 0.212 | 1.000 | 0.215 | 0.188 | 0.032 | 0.065 | 0.066 | 0.212 | 1.000 | 0.118 | 0.117 | 0.037 | 0.037 | 0.055 | 0.054 | 0.115 | 0.114 | 0.081 | 0.000 | 0.000 | 0.000 | 0.055 | 0.054 | 0.014 |
| numero_adultos | 0.098 | 0.112 | -0.921 | 0.081 | 0.083 | 1.000 | 0.039 | 0.000 | 0.019 | 0.004 | -0.829 | 0.106 | 0.118 | 0.083 | 0.039 | 0.000 | 0.019 | 0.004 | 0.106 | 0.118 | 1.000 | -0.921 | 0.169 | -0.146 | 0.898 | -0.893 | 0.981 | -0.912 | 0.020 | 0.946 | 0.946 | 0.946 | 0.957 | -0.956 | 0.857 |
| numero_adultos_anio_anterior | 0.097 | 0.111 | 1.000 | 0.080 | 0.083 | 0.315 | 0.035 | 0.000 | 0.019 | 0.005 | 0.833 | 0.104 | 0.117 | 0.083 | 0.035 | 0.000 | 0.019 | 0.005 | 0.104 | 0.117 | -0.921 | 1.000 | -0.145 | 0.170 | -0.892 | 0.901 | -0.911 | 0.982 | 0.020 | 0.946 | 0.946 | 0.946 | -0.957 | 0.958 | -0.849 |
| numero_menores | 0.023 | 0.032 | -0.145 | 0.017 | 0.037 | 0.377 | 0.030 | 0.000 | 0.018 | 0.000 | -0.143 | 0.032 | 0.037 | 0.037 | 0.030 | 0.000 | 0.018 | 0.000 | 0.032 | 0.037 | 0.169 | -0.145 | 1.000 | -0.023 | 0.157 | -0.141 | 0.258 | -0.144 | 0.000 | 0.095 | 0.095 | 0.095 | 0.155 | -0.150 | 0.130 |
| numero_menores_anio_anterior | 0.023 | 0.032 | 0.170 | 0.017 | 0.036 | 0.038 | 0.030 | 0.000 | 0.018 | 0.000 | 0.119 | 0.032 | 0.037 | 0.036 | 0.030 | 0.000 | 0.018 | 0.000 | 0.032 | 0.037 | -0.146 | 0.170 | -0.023 | 1.000 | -0.141 | 0.158 | -0.144 | 0.257 | 0.000 | 0.096 | 0.096 | 0.096 | -0.152 | 0.156 | -0.135 |
| numero_noches | 0.000 | 0.000 | -0.892 | 0.000 | 0.000 | 0.011 | 0.000 | 0.007 | 0.000 | 0.000 | -0.812 | 0.031 | 0.055 | 0.000 | 0.000 | 0.007 | 0.000 | 0.000 | 0.031 | 0.055 | 0.898 | -0.892 | 0.157 | -0.141 | 1.000 | -0.864 | 0.889 | -0.883 | 0.000 | 0.007 | 0.007 | 0.007 | 0.928 | -0.925 | 0.849 |
| numero_noches_anio_anterior | 0.000 | 0.000 | 0.901 | 0.000 | 0.000 | 0.000 | 0.002 | 0.000 | 0.000 | 0.000 | 0.799 | 0.028 | 0.054 | 0.000 | 0.002 | 0.000 | 0.000 | 0.000 | 0.028 | 0.054 | -0.893 | 0.901 | -0.141 | 0.158 | -0.864 | 1.000 | -0.884 | 0.892 | 0.000 | 0.006 | 0.006 | 0.006 | -0.928 | 0.930 | -0.823 |
| numero_personas | 0.091 | 0.107 | -0.911 | 0.071 | 0.085 | 0.647 | 0.042 | 0.004 | 0.021 | 0.010 | -0.817 | 0.104 | 0.115 | 0.085 | 0.042 | 0.004 | 0.021 | 0.010 | 0.104 | 0.115 | 0.981 | -0.911 | 0.258 | -0.144 | 0.889 | -0.884 | 1.000 | -0.902 | 0.015 | 0.230 | 0.230 | 0.230 | 0.947 | -0.946 | 0.844 |
| numero_personas_anio_anterior | 0.090 | 0.107 | 0.982 | 0.071 | 0.085 | 0.087 | 0.042 | 0.004 | 0.021 | 0.010 | 0.829 | 0.103 | 0.114 | 0.085 | 0.042 | 0.004 | 0.021 | 0.010 | 0.103 | 0.114 | -0.912 | 0.982 | -0.144 | 0.257 | -0.883 | 0.892 | -0.902 | 1.000 | 0.015 | 0.232 | 0.232 | 0.232 | -0.947 | 0.949 | -0.841 |
| pais_agencia | 1.000 | 0.058 | 0.020 | 1.000 | 0.181 | 0.036 | 0.062 | 0.092 | 0.088 | 0.010 | 0.062 | 0.501 | 0.081 | 0.181 | 0.062 | 0.092 | 0.088 | 0.010 | 0.501 | 0.081 | 0.020 | 0.020 | 0.000 | 0.000 | 0.000 | 0.000 | 0.015 | 0.015 | 1.000 | 0.000 | 0.000 | 0.000 | 0.002 | 0.002 | 0.000 |
| reservacion | 0.000 | 0.000 | 0.946 | 0.000 | 0.000 | 1.000 | 0.017 | 0.000 | 0.000 | 0.000 | 0.993 | 0.000 | 0.000 | 0.000 | 0.017 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.946 | 0.946 | 0.095 | 0.096 | 0.007 | 0.006 | 0.230 | 0.232 | 0.000 | 1.000 | 1.000 | 1.000 | 0.998 | 0.998 | 0.010 |
| reservacion_anio_anterior | 0.000 | 0.000 | 0.946 | 0.000 | 0.000 | 1.000 | 0.017 | 0.000 | 0.000 | 0.000 | 0.993 | 0.000 | 0.000 | 0.000 | 0.017 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.946 | 0.946 | 0.095 | 0.096 | 0.007 | 0.006 | 0.230 | 0.232 | 0.000 | 1.000 | 1.000 | 1.000 | 0.998 | 0.998 | 0.010 |
| reservacion_pendiente | 0.000 | 0.000 | 0.946 | 0.000 | 0.000 | 1.000 | 0.017 | 0.000 | 0.000 | 0.000 | 0.993 | 0.000 | 0.000 | 0.000 | 0.017 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.946 | 0.946 | 0.095 | 0.096 | 0.007 | 0.006 | 0.230 | 0.232 | 0.000 | 1.000 | 1.000 | 1.000 | 0.998 | 0.998 | 0.010 |
| total_habitaciones | 0.039 | 0.046 | -0.957 | 0.033 | 0.045 | 0.421 | 0.039 | 0.000 | 0.028 | 0.049 | -0.864 | 0.050 | 0.055 | 0.045 | 0.039 | 0.000 | 0.028 | 0.049 | 0.050 | 0.055 | 0.957 | -0.957 | 0.155 | -0.152 | 0.928 | -0.928 | 0.947 | -0.947 | 0.002 | 0.998 | 0.998 | 0.998 | 1.000 | -0.993 | 0.884 |
| total_habitaciones_anio_anterior | 0.038 | 0.046 | 0.958 | 0.032 | 0.044 | 0.407 | 0.038 | 0.000 | 0.027 | 0.049 | 0.862 | 0.049 | 0.054 | 0.044 | 0.038 | 0.000 | 0.027 | 0.049 | 0.049 | 0.054 | -0.956 | 0.958 | -0.150 | 0.156 | -0.925 | 0.930 | -0.946 | 0.949 | 0.002 | 0.998 | 0.998 | 0.998 | -0.993 | 1.000 | -0.881 |
| total_tarifa | 0.000 | 0.015 | -0.849 | 0.000 | 0.003 | 0.000 | 0.027 | 0.000 | 0.000 | 0.000 | -0.767 | 0.008 | 0.014 | 0.003 | 0.027 | 0.000 | 0.000 | 0.000 | 0.008 | 0.014 | 0.857 | -0.849 | 0.130 | -0.135 | 0.849 | -0.823 | 0.844 | -0.841 | 0.000 | 0.010 | 0.010 | 0.010 | 0.884 | -0.881 | 1.000 |
Missing values
Sample
| id_reservaciones | fecha_hoy | fecha_reservacion | fecha_llegada | fecha_salida | numero_personas | numero_personas_anio_anterior | numero_adultos | numero_adultos_anio_anterior | numero_menores | numero_menores_anio_anterior | numero_noches | numero_noches_anio_anterior | total_habitaciones | total_habitaciones_anio_anterior | id_programa | nombre_programa | id_paquete | nombre_paquete | id_segmento | nombre_segmento | id_agencia | nombre_agencia | ciudad_agencia | entidad_federativa_agencia | pais_agencia | id_empresa | nombre_empresa | total_habitaciones_empresa | id_tipo_habitacion | nombre_tipo_habitacion | cupo_tipo_habitacion | clasificacion_tipo_habitacion | id_canal | nombre_canal | id_pais_origen | nombre_pais_origen | reservacion_pendiente | id_estatus_reservacion | nombre_estatus_reservacion | clave_estado | nombre_estado | total_tarifa | id_moneda | fecha_ultimo_cambio | reservacion | reservacion_anio_anterior | id_cliente_disp | cliente_disp_anio_anterior | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 2019-08-16 | 2019-08-16 | 2019-07-11 | 2019-10-11 | 2 | 0 | 2 | 0 | 0 | 0 | 3 | 0 | 1 | 0 | 1 | Ninguno | 1 | Walk In | 14 | Individual Ep/vac. Club | 112 | Hoteles S.a. | Mexico City | México | México | 1 | Hotel 1 | 735 | 25 | Estd 2q Sn12mst | 2.0 | Mst | 10 | Multivacaciones 2 | 157 | Mexico | True | 9 | Salida | Emx | México | 2659.98 | 1 | 2019-10-11 | True | False | 2 | 0 |
| 1 | 1 | 2019-10-22 | 2019-10-22 | 2019-01-12 | 2019-05-12 | 4 | 0 | 4 | 0 | 0 | 0 | 4 | 0 | 1 | 0 | 1 | Ninguno | 2 | Ninguno | 14 | Individual Ep/vac. Club | 112 | Hoteles S.a. | Mexico City | México | México | 1 | Hotel 1 | 735 | 25 | Estd 2q Sn12mst | 2.0 | Mst | 10 | Multivacaciones 2 | 157 | Mexico | True | 9 | Salida | Egt | Guanajuato | 1764.00 | 1 | 2019-05-12 | True | False | 4 | 0 |
| 2 | 2 | 2019-10-28 | 2019-10-28 | 2019-01-12 | 2019-05-12 | 2 | 0 | 2 | 0 | 0 | 0 | 4 | 0 | 1 | 0 | 1 | Ninguno | 1 | Walk In | 14 | Individual Ep/vac. Club | 112 | Hoteles S.a. | Mexico City | México | México | 1 | Hotel 1 | 735 | 23 | Jr Suite 1k Sn12mjs | 2.0 | Mjs | 10 | Multivacaciones 2 | 157 | Mexico | True | 9 | Salida | Emc | Michoacán | 2660.04 | 1 | 2019-05-12 | True | False | 2 | 0 |
| 3 | 3 | 2019-10-28 | 2019-10-28 | 2019-08-12 | 2019-11-12 | 4 | 0 | 3 | 0 | 0 | 0 | 3 | 0 | 1 | 0 | 1 | Ninguno | 2 | Ninguno | 14 | Individual Ep/vac. Club | 112 | Hoteles S.a. | Mexico City | México | México | 1 | Hotel 1 | 735 | 24 | Jr Suite 2q Sn12mjs | 2.0 | Mjs | 10 | Multivacaciones 2 | 157 | Mexico | True | 9 | Salida | Egt | Guanajuato | 1995.03 | 1 | 2019-11-12 | True | False | 3 | 0 |
| 4 | 4 | 2019-10-28 | 2019-10-28 | 2019-08-12 | 2019-12-12 | 2 | 0 | 2 | 0 | 0 | 0 | 4 | 0 | 1 | 0 | 1 | Ninguno | 1 | Walk In | 5 | Ecommerce Ota Domestic | 14 | Bestday Travel Group | Cancún | Quintana Roo | México | 1 | Hotel 1 | 735 | 4 | Luxury 2q Sn12gsu | 2.0 | Gsu | 13 | Vertical Booking | 157 | Mexico | True | 9 | Salida | Emx | México | 13369.92 | 1 | 2019-12-12 | True | False | 2 | 0 |
| 5 | 5 | 2019-05-08 | 2019-05-08 | 2019-01-12 | 2019-05-12 | 6 | 0 | 6 | 0 | 0 | 0 | 4 | 0 | 1 | 0 | 1 | Ninguno | 1 | Walk In | 14 | Individual Ep/vac. Club | 112 | Hoteles S.a. | Mexico City | México | México | 1 | Hotel 1 | 735 | 24 | Jr Suite 2q Sn12mjs | 2.0 | Mjs | 12 | Sitio Propio | 157 | Mexico | True | 9 | Salida | Egt | Guanajuato | 2660.04 | 1 | 2019-05-12 | True | False | 6 | 0 |
| 6 | 6 | 2019-07-19 | 2019-07-19 | 2019-08-22 | 2019-08-25 | 2 | 0 | 2 | 0 | 0 | 0 | 3 | 0 | 1 | 0 | 1 | Ninguno | 1 | Walk In | 14 | Individual Ep/vac. Club | 112 | Hoteles S.a. | Mexico City | México | México | 1 | Hotel 1 | 735 | 25 | Estd 2q Sn12mst | 2.0 | Mst | 10 | Multivacaciones 2 | 157 | Mexico | True | 2 | Reservacion Cancelada | Egr | Guerrero | 3331.98 | 1 | 2019-07-24 | True | False | 2 | 0 |
| 7 | 7 | 2019-07-19 | 2019-07-19 | 2019-08-23 | 2019-08-25 | 2 | 0 | 2 | 0 | 0 | 0 | 2 | 0 | 1 | 0 | 1 | Ninguno | 1 | Walk In | 5 | Ecommerce Ota Domestic | 14 | Bestday Travel Group | Cancún | Quintana Roo | México | 1 | Hotel 1 | 735 | 4 | Luxury 2q Sn12gsu | 2.0 | Gsu | 1 | Lada 800 Nacional68 | 157 | Mexico | True | 9 | Salida | Emc | Michoacán | 8809.92 | 1 | 2019-08-25 | True | False | 2 | 0 |
| 8 | 8 | 2019-07-19 | 2019-07-19 | 2019-08-25 | 2019-08-29 | 3 | 0 | 2 | 0 | 0 | 0 | 4 | 0 | 1 | 0 | 1 | Ninguno | 2 | Ninguno | 14 | Individual Ep/vac. Club | 112 | Hoteles S.a. | Mexico City | México | México | 1 | Hotel 1 | 735 | 26 | Mv Luxury 2q Sn12gsu | 2.0 | Gsu | 10 | Multivacaciones 2 | 157 | Mexico | True | 9 | Salida | Egr | Guerrero | 2548.00 | 1 | 2019-08-29 | True | False | 2 | 0 |
| 9 | 9 | 2019-06-05 | 2019-06-05 | 2019-08-25 | 2019-08-29 | 2 | 0 | 2 | 0 | 0 | 0 | 4 | 0 | 1 | 0 | 1 | Ninguno | 2 | Ninguno | 14 | Individual Ep/vac. Club | 112 | Hoteles S.a. | Mexico City | México | México | 1 | Hotel 1 | 735 | 27 | Mv Luxury 1k Sn12gsu | 2.0 | Gsu | 10 | Multivacaciones 2 | 157 | Mexico | True | 9 | Salida | Emc | Michoacán | 2548.00 | 1 | 2019-08-29 | True | False | 2 | 0 |
| id_reservaciones | fecha_hoy | fecha_reservacion | fecha_llegada | fecha_salida | numero_personas | numero_personas_anio_anterior | numero_adultos | numero_adultos_anio_anterior | numero_menores | numero_menores_anio_anterior | numero_noches | numero_noches_anio_anterior | total_habitaciones | total_habitaciones_anio_anterior | id_programa | nombre_programa | id_paquete | nombre_paquete | id_segmento | nombre_segmento | id_agencia | nombre_agencia | ciudad_agencia | entidad_federativa_agencia | pais_agencia | id_empresa | nombre_empresa | total_habitaciones_empresa | id_tipo_habitacion | nombre_tipo_habitacion | cupo_tipo_habitacion | clasificacion_tipo_habitacion | id_canal | nombre_canal | id_pais_origen | nombre_pais_origen | reservacion_pendiente | id_estatus_reservacion | nombre_estatus_reservacion | clave_estado | nombre_estado | total_tarifa | id_moneda | fecha_ultimo_cambio | reservacion | reservacion_anio_anterior | id_cliente_disp | cliente_disp_anio_anterior | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 202992 | 202992 | 2020-05-02 | 2019-05-02 | 2019-04-19 | 2019-04-26 | 0 | 4 | 0 | 2 | 0 | 2 | 0 | 7 | 0 | 1 | 1 | Ninguno | 1 | Walk In | 18 | Tour Operators Internationals | 116 | Sunwing Vacations | Toronto | Ontario | Canada | 1 | Hotel 1 | 735 | 17 | Estd C/balcon Sn12asb | 2.0 | Asb | 0 | Sin Definir | 38 | Canada | False | 9 | Salida | Eca | California | 0.0 | 1 | 2019-04-26 | False | True | 0 | 2 |
| 202993 | 202993 | 2020-10-04 | 2019-10-04 | 2019-10-04 | 2019-04-13 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 3 | 0 | 1 | 1 | Ninguno | 2 | Ninguno | 14 | Individual Ep/vac. Club | 112 | Hoteles S.a. | Mexico City | México | México | 1 | Hotel 1 | 735 | 19 | Estd Db Sn12ast | 2.0 | Ast | 1 | Lada 800 Nacional68 | 0 | Sin Definir | False | 9 | Salida | Emc | Michoacán | 0.0 | 1 | 2019-04-13 | False | True | 0 | 2 |
| 202994 | 202994 | 2020-10-04 | 2019-10-04 | 2019-10-04 | 2019-04-13 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 3 | 0 | 1 | 1 | Ninguno | 2 | Ninguno | 14 | Individual Ep/vac. Club | 112 | Hoteles S.a. | Mexico City | México | México | 1 | Hotel 1 | 735 | 19 | Estd Db Sn12ast | 2.0 | Ast | 1 | Lada 800 Nacional68 | 0 | Sin Definir | False | 9 | Salida | Emc | Michoacán | 0.0 | 1 | 2019-04-13 | False | True | 0 | 2 |
| 202995 | 202995 | 2020-10-04 | 2019-10-04 | 2019-10-04 | 2019-04-13 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 3 | 0 | 1 | 1 | Ninguno | 2 | Ninguno | 14 | Individual Ep/vac. Club | 112 | Hoteles S.a. | Mexico City | México | México | 1 | Hotel 1 | 735 | 19 | Estd Db Sn12ast | 2.0 | Ast | 1 | Lada 800 Nacional68 | 0 | Sin Definir | False | 9 | Salida | Emc | Michoacán | 0.0 | 1 | 2019-04-13 | False | True | 0 | 2 |
| 202996 | 202996 | 2020-10-04 | 2019-10-04 | 2019-10-04 | 2019-10-04 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 3 | 0 | 1 | 1 | Ninguno | 2 | Ninguno | 14 | Individual Ep/vac. Club | 112 | Hoteles S.a. | Mexico City | México | México | 1 | Hotel 1 | 735 | 19 | Estd Db Sn12ast | 2.0 | Ast | 1 | Lada 800 Nacional68 | 0 | Sin Definir | False | 2 | Reservacion Cancelada | Emc | Michoacán | 0.0 | 1 | 2019-10-04 | False | True | 0 | 2 |
| 202997 | 202997 | 2020-10-04 | 2019-10-04 | 2019-10-04 | 2019-10-04 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 3 | 0 | 1 | 1 | Ninguno | 2 | Ninguno | 14 | Individual Ep/vac. Club | 112 | Hoteles S.a. | Mexico City | México | México | 1 | Hotel 1 | 735 | 19 | Estd Db Sn12ast | 2.0 | Ast | 1 | Lada 800 Nacional68 | 0 | Sin Definir | False | 2 | Reservacion Cancelada | Emc | Michoacán | 0.0 | 1 | 2019-10-04 | False | True | 0 | 2 |
| 202998 | 202998 | 2020-06-17 | 2019-06-17 | 2019-06-17 | 2019-06-17 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | Ninguno | 1 | Walk In | 14 | Individual Ep/vac. Club | 112 | Hoteles S.a. | Mexico City | México | México | 1 | Hotel 1 | 735 | 13 | Sup Luj King Sn12asb | 2.0 | Asb | 1 | Lada 800 Nacional68 | 0 | Sin Definir | False | 9 | Salida | Egr | Guerrero | 0.0 | 1 | 2019-06-17 | False | True | 0 | 2 |
| 202999 | 202999 | 2020-05-30 | 2019-05-30 | 2019-05-30 | 2019-02-06 | 0 | 3 | 0 | 2 | 0 | 0 | 0 | 3 | 0 | 1 | 1 | Ninguno | 2 | Ninguno | 14 | Individual Ep/vac. Club | 112 | Hoteles S.a. | Mexico City | México | México | 1 | Hotel 1 | 735 | 17 | Estd C/balcon Sn12asb | 2.0 | Asb | 1 | Lada 800 Nacional68 | 0 | Sin Definir | False | 9 | Salida | Emc | Michoacán | 0.0 | 1 | 2019-02-06 | False | True | 0 | 2 |
| 203000 | 203000 | 2020-10-08 | 2019-10-08 | 2019-10-08 | 2019-12-08 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 2 | 0 | 1 | 1 | Ninguno | 1 | Walk In | 5 | Ecommerce Ota Domestic | 14 | Bestday Travel Group | Cancún | Quintana Roo | México | 1 | Hotel 1 | 735 | 6 | Luxury 1k Sn12gsu | 2.0 | Gsu | 1 | Lada 800 Nacional68 | 0 | Sin Definir | False | 9 | Salida | Emc | Michoacán | 0.0 | 1 | 2019-12-08 | False | True | 0 | 2 |
| 203001 | 203001 | 2020-02-24 | 2019-02-24 | 2019-02-24 | 2019-02-28 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 4 | 0 | 1 | 1 | Ninguno | 2 | Ninguno | 14 | Individual Ep/vac. Club | 112 | Hoteles S.a. | Mexico City | México | México | 1 | Hotel 1 | 735 | 25 | Estd 2q Sn12mst | 2.0 | Mst | 1 | Lada 800 Nacional68 | 0 | Sin Definir | False | 9 | Salida | Emc | Michoacán | 0.0 | 1 | 2019-02-28 | False | True | 0 | 2 |